Conditional Formatting for 4 conditions

[Steve]

How can I set up conditional formatting for the following:

3.5 = red

2.5 - 3.49 = yellow
2 - 2.49 = green
<2 = blue

Thanks,

Steve

 

[Bob Phillips]

Set all the cells to one of the colours that apply the 3 conditions to them
via CF, effectively 4 colours.

 

[Steve]

Perfect.

Thanks

Set all the cells to one of the colours that apply the 3 conditions to them
via CF, effectively 4 colours.

--

HTH

Bob




.