Three conditional format senarios

[obiwann]

I need a conditional format formula to turn cell A1 colour to blue if cell A1 is < cell B1 and greater than C1, or Cell A1 to colour red if cell A1 is greater then cell B1 or leave cell A1 with no clour if A1 is less than C1.

A1 = 0.5
B1 = 1.0
C1 = 0.75

I am stumped.

Any help would be appreciated

 

[jtakw]

Hi,

You'll need 2 CF rules, no rule needed for "No Color" when A1 is less than C1.

Book1
	A	B	C	D	E	F
1	0.5	1	0.75		For Blue	FALSE
2					For Red	FALSE
Sheet358

Cell Formulas
Range	Formula
F1	=AND(A1C1)
F2	=A1>B1