Thanks Bernie...

I finally figured it out the other day....

I felt so dumb....the whole time, the formatting wasn't working because I
wasn't in the first cell of the row I was trying to fix....

I do have another question that would be great if you can help with...it is
a separate thread "Macro - message box if find nothing"....Jim Rech was
helping, but he decided I should be able to figure it out on my own, and I am
stuck...If you don't mind reading thru, I would appreciate some input...

Thanks again...

Sara

"Bernie Deitrick" wrote:

Sorry, Frantic - I went on a short vacation...


Range("H:H").Select
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="=""India Only"""
Selection.FormatConditions(1).Interior.ColorIndex = 7
Selection.FormatConditions.Add Type:=xlExpression,
Formula1:="=ISERROR(H1)"
Selection.FormatConditions(2).Interior.ColorIndex = 7


HTH,
Bernie
MS Excel MVP


"Frantic Excel-er" wrote in
message ...
Bernie.....help......please......I am really trying hard......I have been
at
it for almost 4 hours........going crazy....

Can't figure out how to conditional format when the formula result is
#N/A.....

"Bernie Deitrick" wrote:

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?????