change the color of one word throughout a worksheet

[Guest]

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

 

[pzeitlin]

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

Is it one word in the cell or cojoined with other words? A
Conditional Formatting will solve that if the word is soley on it's
own in the cell. If you need help with it, let me (or anyone) know.

 

[Guest]

Conditional Formatting
Cell Value Is; equal to; Yes

 

[Guest]

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