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

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

--

HTH

Bob

"Steve" wrote in message
...
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

Perfect.

Thanks

"Bob Phillips" wrote:

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

--

HTH

Bob

"Steve" wrote in message
...
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


.