Don't use code, use conditional formatting. Look in help.

HTH,
Bernie
MS Excel MVP


"Frantic Excel-er" wrote in message
...
Bernie,

I have some more formatting issues now that pertain to the code you wrote me
in this thread.

I now need to find in column H...all the cells that have a formula response
of #N/A, or "India Only", and I need to highlight those in red. I tried to
copy this code that formatted the other column for me, but it doesn't work -
I get a duplicate compile error. Any suggestions on how I can get these
responses highlighted????

Thanks.

Sara

"Bernie Deitrick" wrote:

Lurk here and read the posts and answers, and read any book in the VBA Power
Programming series by John Walkenbach.

HTH,
Bernie
MS Excel MVP


"Frantic Excel-er" wrote in
message ...
Hi Bernie,

Thanks so much for all the help....The code works great....I can't stop
re-running it just to see it work.....This is very helpful....and also,
thanks for the tip on finding the word first, and then executing the
formating steps.....I would have never even known you can do that.....

One more question........what would be a good direction to go in to learn
more about visual basic?????