On Nov 19, 1:12 pm, 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?

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.