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