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

  • Thread starter Thread starter Jen O.P.
  • Start date Start date
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.
 
Hi,

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

=isna(a1)

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 4
Conditional Formatting 2
working with #N/A and conditional formating 1
#N/A Conditional Formatting affects all cells? 9
Conditional Formatting by percent range 2
Help with Conditional Formatting 2
Conditional formatting - check for blank cell 3
Conditional format Formula -Duplicate & n/a 1

Back
Top