Highlight a certain word ?

A

Andy100

How do i get Excel 2002 to highlight every instance of a word ?, similar to
a conditional format, but i want every instance of a word to be in red ?

Cheers
Andy
 
Top