How can I conditionally format any cell that does NOT contain #N/A in it. Example:

In column A

100
200
#N/A
100
50
#N/A
45

I want to color only cells that do not contain #N/A

I am using Excel 2007 if it helps...but am sure the formula would be the same in either one.

-

I Got it! I use the Format Cells that contain - <>NOT EQUAL TO - "#N/A" and color code...it now works fine.