IS ERROR didn't work. Not to be a thick-head but I don't quite understand
what you mean in adding this statement to my formula. Can you give an
example please?

"PCLIVE" wrote:

Maybe something like this in your conditional formatting:

=ISERROR(A2)

You also apply this type of statement to your formulas in the cell instead
of using conditional formatting.

HTH,
Paul

--

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