Thread: "If" statement?
View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

How about conditional formatting. You could have a condition like

=A1=$A$1

where the word is in A1, and apply to a whole range.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"baileygrrrl" wrote in message
...
Is there a way to have excel to highlight each instance of a particular

word
in a file?

Eg. I need excel to look for the word "delivered" in a worksheet and
highlight it each time it finds that word - by highlight I mean change the
text colour or cell shading or some other way to make it stand out.