#N/A Conditional Formating

[Hardeep kanwar]

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

 

[Satti Charvak]

us the formula isna....to check if there is any #ns error.

it would be like =isna(vlookup(....)) in the conditional format formula...

in place of dots put the vlookup formula that you using

 

[Hardeep Kanwar]

Thanks Satti Charvak

But I Already got the Answer

Thanks Again for your Valuable Suggestion

Hardeep kanwar