If, Then formula to change cell color?

[The Hun]

Using Excel 2002
Is there an If / Then / Else formula to change cell color? How do I
write a formula to search a range of cells for the word "Yes" and
change the Fill Color of each cell with the word "Yes" in it? And
does the Excel HELP section discuss this?

Thanks,

 

[David Heaton]

Using Excel 2002
Is there an If / Then / Else formula to change cell color?  How do I
write a formula to search a range of cells for the word "Yes" and
change the Fill Color of each cell with the word "Yes" in it?  And
does the Excel HELP section discuss this?

Thanks,

You can use conditional formatting .

Highlight the area you wish to check, goto to Format menu, then
Conditional Formatting.
Select "Formula is" and enter the formula below.

=NOT(ISERROR(FIND("yes",A1)))

you'll need to replace A1 with the first selected cell in your range

hth

Regards

David