Conditional Formatting - recognise #N/A

[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. Valko]

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

=ISNA(cell_reference)

Replace cell_reference with the actual cell reference.

 

[LinLin]

That was very cool T. Valko - many thanks and have a great weekend!

 

[T. Valko]

You're welcome. Thanks for the feedback!