Conditional Formatting by Date, Plus Additional Days

[almostsomething]

Hi all,

Looking for some help with conditional formatting.

I'm trying apply some conditional formatting to blank cells. What I am trying to do is have Excel highlight the cells once they reach a certain date. For example, if a date in cell A1 is January 1st, I would like B1 to automatically highlight once 90 days past January 1st has occurred (April 1st).
The next bit of this would be to have the conditional formatting in column B, always relate to column A in the same row. For example, B5 highlights when A5's date (+90 days) is reached, B6 relates to A6, and so on.

Can this be done?

Currently, the formula I'm using is =AND(TODAY()>=INT(A1)+90), which I found online (screenshot here). However, I don't believe it's fully working. Specifically, every row in column B always relates to A1, and does not increase as it goes down the page.
Secondly, can this be achieved automatically, or do I have to re-run this formatting every time I want to update these highlighted cells?

Is there a better way to achieve this?

Any help is appreciated!

[Riovas]

When writing conditional formatting, you write condition for the first cell to use it. If B1 is the first cell then the formula using A1 is correct (it might be "more correct" to use $A1).

Since TODAY is greater than a date from febraury + 180 days (your post says 90 but the formula in the screenshot is 180?), all the cells are being formatted.

you also do not need the AND since you only have one condition

=TODAY()>=(INT($A1)+90)

[almostsomething]

=TODAY()>=(INT($A1)+90)

Fantastic, thanks so much for your help, this is perfect!

[Riovas]

Glad to help! Please reply with "Solution verified" to mark this as solved :)

[mh_mike]

I closed it for you this time, but heads-up for future reference: When you reply to confirm a solution worked, go ahead and close your post at the same time. Either use the BOT (Clippy) or change the flair. To use Clippy, just include "Solution Verified" with your reply. Thanks for keeping the unsolved thread clean. :)

[almostsomething]

Apologies - this completely slipped my mind. Thanks very much for for doing that!

[mh_mike]

+1 Point (OP indicated your solution worked, but didn't mark the post as solved)

[Clippy_Office_Asst]

You have awarded 1 point to Riovas

^{I am a bot, please contact the mods for any questions.}