Conditional formating

[mira2020]

Hi All,

I want to do this condition formatting color but the conditioning formating include lowest and highest value.
any tips for this problem ?thanks

Red	Amber	Green
x<=80	80<x<90	x>=90

 

[jtakw]

Hi,

You almost have all your formulas already, use these for CF:

Book3.xlsx
	A	B	C
1	50	TRUE	Red
2		FALSE	Amber
3		FALSE	Green
Sheet903

Cell Formulas
Range	Formula
B1	B1	=AND(A1<>"",A1<=80)
B2	B2	=AND(A1>80,A1<90)
B3	B3	=A1>=90

 

[Peter_SSs]

What about using a Conditional Formatting 'Icon Set' with settings like this.

Result:

 

[johnnyL]

Try Conditional Formatting/Highlight Cells Rules