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

  • Thread starter Thread starter Manosh
  • Start date Start date
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
 
Back
Top