#N/A Conditional Formating

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
 
G

Gary''s Student

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
 
B

Bob Phillips

You have a response at your post in MrExcel.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
H

Hardeep kanwar

Yes, I Know Sir

Please Accept my Apologies if I Break the Rules.

But Bob Sometimes we will not get the answer from a particular site, So
thats Why a person like me POST the Questions in Many Sites

Sorry Again

Hardeep kanwar
 
G

Gord Dibben

If you must post to multiple sites then cross-post rather than multi-post so
responders know what groups you have posted to.


Gord Dibben MS Excel MVP
 
F

Francis

Hi

Nobody against crossposting, if the answer you get is not what you want,
have you informed and described to the people who have try providing you the
solution?

It is manner / netiquette to provide a link to the earlier post in another
forum and state the reason for cross posting but do not cross post in more
than 2 forums.
And if you get the solution, go back and provide a link to the solution

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another
 
F

Fred Smith

So wasting other people's time isn't an issue with you? If too many people
operate the way you do, responders will stop posting because they get no
feedback. If you want to run the risk of losing responders, continue doing
what you're doing.

Regards,
Fred.
 
B

Bob Phillips

Francis said:
Hi

Nobody against crossposting, if the answer you get is not what you want,
have you informed and described to the people who have try providing you
the
solution?

I am against it! I see no reason at all to post to many sites at the same
time. If they fail to get a resolution at one, then it is more appropriate
to try another explaining why it is being done, and giving a link to the
previous thread.

If the poster tells me they are cross-posting then I can ignore them at my
leisure, but if they don't, time is wasted. Either I or Gary's Student
wasted are time with this guy.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top