Conditional Formatting while calculating number of days...

[Syrain]

I can google with the best of them, and I still can't figure this out...

I have a user who is trying to conditionally format a cell, I'll try and explain this to the best of my ability:

Cell A1 is Today() to display the current date.
Cell(s) Y7 - Y50 is a date in the future.
Cell(s) AA7 - AA50 are where the conditional formatting should take place.

If the date in Y7 is equal or greater than 28 days passed the date in A1 (Today()) then AA7 should be filled in red. And so on.

Can anyone possibly help me?

[Miraun]

Try the following:

Apply to column AA7

$Y7>= Today()+28

been a while since I worked with conditional formatting, and have a meeting to run off to, but that may help. If you anchor one part of the equation, the non-anchored part will fluctuate with the cell being formatted.

[Syrain]

That works when put into the cell itself as a formula, returns a TRUE if it's greater than 28 days, and a FALSE if not. But when I try and put that into conditional formatting, it does nothing.

[Syrain]

I got it! Thank you so much!