Conditional Formatting using Formula

[andrewc]

I am trying to conditionally format some data in cells A3:A6 (shade the cells) depending on whether a number in B1 is 1 (green), 2 or 3 (blue), or 4 (red). Can someone please suggest how I go about doing this?

Thanks

[NBVC]

Invoke Conditional formatting from Format menu...


Select

Cell Value is >> Equal to =1...format Green ... Ok

Click Add

Cell Value is >> Between =2 and =3 ...format Blue ... Ok

Click Add

Cell Value is >> Equal to =4 format Red ... Ok

Ok

[stanleydgromjr]

andrewc,

Highlite cells A3:A6, and click on "Format", "Conditional Formatting…"
Condition 1
Formula Is
=B3=1
Click the "Format" button and click on the GREEN color, and click OK
Click on "Add" button

Condition 2
Formula Is
=OR(B3=2,B3=3)
Click the "Format" button and click on the BLUE color, and click OK
Click on "Add" button

Condition 3
Formula Is
=B3=4
Click the "Format" button and click on the RED color, and click OK
Then click on the "OK" button

[andrewc]

Perfect, thanks very much!