multiple conditional formating

[Guest]

i want to create a conditional format/formula that will do the following
if cell <2 then colour green or if same cell is >=2 or <15 then colour
yellow or if same cell is >=15 then colour red

 

[Biff]

Hi!

Try this:

Select the cell you want formatted. Assume this is cell A1.
Goto the menu Format>Conditional Formatting

Condition 1
Formula Is: =AND(ISNUMBER(A1),A1<2)
Click the Format button
Set the fill color to GREEN
OK
Click Add
Condition 2
Formula Is: =AND(A1>=2,A1<15)
Click the Format button
Set the fill color to YELLOW
OK
Click Add
Condition 3
Formula Is: =A1>=15
Click the Format button
Set the fill color to RED
OK out

Biff