3 color conditional formatting

[djungst]

I would like to format a cell based on a calculation of time remaining to a specific date. I would like the highlight to go from green to yellow to red. The formula that I would like to use would be =today()-cell??. If the result is less than 90 the highlight would be red. If the result is less than 60 the highlight would be yellow. If the result is less than 30 the highlight would be green.

[Dunc3142]

Check attached see if this is what you are after.

[djungst]

Dunc3142, made a few adjustments and it works just fine. I actually wanted to highlight a cell based on the value in another cell. When I figured that out, the problem was solved. Thanks for getting me started in the right direction.