Conditional format a cell if it has an error (due to lookup #N/A)

M

Manosh

Hi all,
would like a simple Formula is statement that allows me to highlight
the cell which returns a value of #N/A after a vlookup.
Currently typing cell is equal to #N/A does not seem to work...!
Clearly this #N/A isn't simply a string.
thanks in advance.
manosh
 

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

Hiding #N/A With Conditional Formatting 4
N/A - conditional format so as not to appear in screen 18
working with #N/A and conditional formating 1
Conditional format Formula -Duplicate & n/a 1
Conditional Formating with a formula 2
#N/A Conditional Formatting affects all cells? 9
Lookup functions always return n/a ??? 3
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2

Top