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



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.

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