Conditional Formatting - recognise #N/A

L

LinLin

Hi Everyone

I would like to use Conditional Formatting to highlight for me when #N/A is
the result of a formula.

(I have used Conditional Formatting before for number values, but this has
me stumped!)

Many thanks!
 
T

T. Valko

Use the Formula Is option in conditional formatting and use this formula:

=ISNA(cell_reference)

Replace cell_reference with the actual cell reference.
 

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

can conditional formatting varry the area it highlights based on c 3
Conditional Formatting - find cells containg "+" 3
#N/A Conditional Formatting affects all cells? 9
Conditional Format Fragmentation 2
Date Calculation & Conditional Formatting 3
Excel Conditional Formatting Removal 7
Conditional Formating - by row, not by column (Office 2007) 1
Excel conditional formatting with Weeknum 4

Top