If then statement

  • Thread starter Thread starter sed
  • Start date Start date
S

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