In the Conditional Formatting dialog, change "Cell Value Is" to
"Formula Is" and use a formula like the following and select your
formatting options.

=IF(ISERROR(E4),IF(ERROR.TYPE(E4)=7,TRUE,FALSE),FA LSE)

The formula tests if cell E4 has an error and if so, then tests
whether it is a #N/A error (type = 7). Note that you do need the
ISERROR function as shown. The ERROR.TYPE function itself returns an
error if the referenced cell does not contain an error.

Change the references to E4 to the appropriate cell.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Fri, 24 Oct 2008 13:02:01 -0700, Jman1018
wrote:

I have a VLOOKUP looking up a value on another sheet. I works fine but when
it can't find the value it shows a #N/A. I don't want to see the #N/A in any
of the feilds on this sheet and I know I need to do a conditional format and
turn the text to the same color as the backgroud color. I just don't know
the correct "Formula Is" statement.