#N/A Conditional Formating

  • Thread starter Thread starter Hardeep kanwar
  • Start date Start date
H

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
 
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
 
Thanks Satti Charvak

But I Already got the Answer

Thanks Again for your Valuable Suggestion

Hardeep kanwar
 
Back
Top