Conditional formatting for dates (in the future)...

[Finalfrontier1976]

Hi all,

I'm trying to do 3 rules in conditional formatting to do the following, I can't seem to get it right, can anyone advise on this:

I'm trying to find the formulas for:

Highlight cells that are equal to today's date and 3 months in the future (so let's say today & +90 days)

If over 90 days and a further 90 days again (so basically between 3 and 6 months in the future) then chance cells with those dates

If over 6 months in the future (say today & over 180 days) then all cells with these dates are changed to another colour


Thanks

[PaulM100]

The rules are in the order that you've mentioned
=AND(A2>=TODAY(),A2<=(TODAY()+90))
=AND(A2>(TODAY()+90),A2<=(TODAY()+180))
=A2>=(TODAY()+180)

You could add another one just in case for dates in the past: =A2<(TODAY()

[Finalfrontier1976]

Hi,

Thanks, I've tried that and it doesn't seem to work, I've attached the sheet.

[AliGW]

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below.

[Special-K]

@Finalfrontier1976

Youve put Cell value equal to for all the formulas.
Do this

Clear out all your conditional formatting

Select the range you want to highlight

Conditional Formatting
New Rule
Use a formula to determine...

Then enter the formulas specified

Format as required

[PaulM100]

Instead of using Format only cells that contain use Use a formula to determine which cells to format and add the formula there and format it