If then statement

[sed]

how can I create an if then statement which if the value of the cell a1 is XX
then the cell's background color becomes blue... if cell a2 is xy then color
is green... and if value of a3 is yy then color is red...
ANY HELP?

 

[Tim879]

Use conditional formatting

Format -> Conditional Formatting

 

[Mike Rogers]

sed

In addition to Tim879 when you get into the conditional formating window,
choose "Formula is" then enter =A1="XX" Select format and formate as you want.
select "Add" choose "Formula is" then enter =A2="XY" Formate as you want.
Select "Add" Choose "Formula is" then enter =A3="YY" Formate as you want.


Mike Rogers