Why don't you hide it in your formula that returns the error instead?

=IF(ISNA(VLOOKUP),"",VLOOKUP)

replace VLOOKUP with your vlookup formula


--


Regards,


Peo Sjoblom



"amos" wrote in message
...
This is exactly what I want to do. However this has been suggested and
doesn't work. I have 2003.

"Max" wrote:

You could try adding Condition 2 with a suitable format to mask the #N/A

Assuming B2 is the top left active cell selected within your conditional
formatting range, Formula is: =ISNA(B2)
Format the font color same as fill color
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"amos" wrote:
I have a summary worksheet that references another with a vlookup
table. The
conditional formatting works if a value is entered on the lookup sheet.
However, if the cell isn't filled with a number on the summary sheet I
get
the #N/A. That is what I'm trying to hide this with text color.
PLEASE help?