Conditional Format – SOLVED

Topic

New Reply

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.

Reply | Quote