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

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?

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

Why not do this instead?
=IF(ISNA(VLOOKUPHERE),"",VLOOKUP)
That way, if it's #N/A, then it shows nothing in the cell.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Wendy" wrote in message
...
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?

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

But to answer your question, use:

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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=505813