If, Then formula to change cell color?

  • Thread starter Thread starter The Hun
  • Start date Start date
T

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,
 
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,
Click to expand...

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
 
Back
Top