Cell color change based on date.

Hello Guru's,

I need a formula that will change the color of a cell based on a date and not change once the date has moved on. Conditional formatting will do this but limited to one month out. I need it to make a color change (red) based on 1 month and (yellow) three months out. See attached for what I would like it to look like.

Kind Regards - Bob

Use formulas rather than those presets, such as

1 month - =AND($H3>EOMONTH(TODAY(),0),$H3<=EOMONTH(TODAY(),1))
3 months - =AND($H3>EOMONTH(TODAY(),2),$H3<=EOMONTH(TODAY(),3))

etc.

Bob, thanks for the quick reply, Am I able to set multiple formulas in styles under conditioning?

Yes, you can have lots. I am not sure what the limit is, but I am sure that it is far more than you will ever need.

Hey thanks, I figured it out and it does exactly what I need!