Thanks Gary

Works Perfectly

But What When we have many #N/A in my Sheet



"Gary''s Student" wrote:

Say we have a vlookup() in D1 which is returning #N/A

Select D1 and:

Format Conditional formating... Formula Is =ISERROR(D1)
and then pick the white font
--
Gary''s Student - gsnu200849


"Hardeep kanwar" wrote:

Hello to all

I Enter My Vlookup Formula it give me #N/A Which is Right There is no
Problem with VLOOKUP Formula

Now i want to give Condition If there is any #N/A then i want a White Font
color Not Patten

I Try but could not get Success

Thanks in Advance

Hardeep kanwar