In the Conditional Formatting menu, set Condition 1 Cell Value is equal
to ="trigger"....and then set the formatting desired

Vaya con Dios,
Chuck, CABGx3


"ARJ123" wrote in message
...
How do I highlight specific word occurances with a formula ?