Conditional formatting a #N/A return in a cell? I want it white.

W

Wendy

I would like to format the '#N/A' results (from a VLookup) in a column to be
white or invisible, but because it is neither a value or a formula, I am
having trouble. Any ideas?
 
C

Cutter

But to answer your question, use:

If A1 is the cell you want to Conditionally Format
Under Formula is
=ISNA(A1)
 
Top