Multiple Conditional Formatting.

[SaiAtachi3000]

I'm looking for multiple conditional formatting. What I'm trying to do is get cells to highlight if they are within a certain range of another cell. For ex: if A2 is 2% less than B2, I need it to highlight red. If it is less than 1% percent, equal to or greater than B2 then I need it to highlight yellow. The same for the rest as well. If C2 is less than or D2 by 2 minutes or equal to D2 then highlight yellow. If it's greater than D2 by 2 minutes then highlight red.

 

[rlv01]

Each format 'Condition' requires an excel formula that resolves to TRUE/FALSE to display/hide the conditional format. An example.

Book2
	A	B	C	D	E
1	A	B		Yellow	Red
2	7.76	8		TRUE	TRUE
3	7.82	8		TRUE	TRUE
4	7.88	8		TRUE	FALSE
5	7.9	8		TRUE	FALSE
6	8	8		FALSE	FALSE
7	8.1	8		FALSE	FALSE
8	8.2	8		FALSE	FALSE
9	10	8		FALSE	FALSE
Sheet1 (2)

Cell Formulas
Range	Formula
D2:D9	D2	=($B2-$A2)>($B2/100)
E2:E9	E2	=($B2-$A2)>($B2/100)*2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A9	Expression	=($B2-$A2)>($B2/100)*2	text	NO
A2:A9	Expression	=($B2-$A2)>($B2/100)	text	NO