change the color of one word throughout a worksheet

W

wfbarron

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

pzeitlin

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

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

Bob Umlas, Excel MVP

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
 
Top