changing the color of a cell based on 3 conditions

[charliec]

hi, in cell a1 I have integer values that can range from 1 to 100. Is there a way to get cell b1 to change colors based on the value of cell a1 and the following conditions:

<7 red
7 - 9 yellow
>=10 green

can this be done with a formula or does it need to be done in code? thx.

[kev_]

You can do this easily with 3 simple conditional formatting rules
- they must be placed in sequence shown in picture
- select cell B1 ... click on conditional formatting \ New Rule \ use formula to determine which cells to format
formulas
=A1>0
=A1>6
=A1>9
format each one as you wish

CF Three rules.jpg
.
.
Example in attached workbook

[charliec]

thx! this works great!

[kev_]

you are welcome
Please mark thread SOLVED (ThreadTools@TopOfThread)