Fill color

[Deeks]

Hi all

I am trying to make a cells automatically change their fill color depending on the number that is in the cell.

In my sheet I have numbers in the cell range D6 – D32, the numbers range from 0 – 30. I would like any numbers lower than 6 to automatically fill the cell red, numbers between 7 – 15 to fill the cell orange, numbers between 16 – 22 to remain existing colors and numbers between 23 – 30 to fill the cell green.

Does anyone have any ideas?

Thanks for your help.

Deeks

[jeffreybrown]

Highlight range D6:D32

Enter in conditional formatting in the following order:

=D6<6
Format Fill >> Red

=AND(D6>7,D6<15)
Format Fill >> Orange

=D6>23
Format Fill >> Orange

Adjust numbers if neccesary

[Deeks]

Thanks for your help, I really appreciate it. I will give this a try tomorrow morning.

Thanks again.