You can also do it if the cell CONTAINS yes (but the whole cell would get the
formatting, not just the word). Select ALL cells; Conditional Formatting:
Formula is:
=NOT(ISERROR(FIND("yes",A1)))
Bob Umlas
Excel MVP

"wfbarron" wrote:

I gave a worksheet that has yes and no answers, how can I change the color of
the word yes throughout the worksheet?