Conditionally formatting cells with "#N/A" as value

J

Jen O.P.

I want all cells with a value of "#N/A" to show up as shaded and I can't get
any result. I am using cell value is equal to "#N/A" and nothing!
I am using Excel 2003.
 
D

David Biddulph

There is a distinction between the text string "#N/A" and the error code
NA()
 
M

Mike H

Hi,

Select thos cells and assuming A1 is at the top of the range use the
conditional format formula

=isna(a1)

Mike
 
Top