Dates

[rombouya]

Hi

I'm currently working on a spreadsheet for a skill matrix.

I would like a function that shows me when a certain evalution is 3 months ago.

So when the date is 3 months back in time it should become red.
When the date is less than 3 months ago it should be green.

Can anyone help me please?

[63falcondude]

Hello and welcome to the forum.

What you are looking to do can be achieved through two Conditional Formatting Rules, one for red and one for green.

I am assuming that the date is in cell A2 and that the cell should turn red for all dates ≥ 3 months ago and green for all dates < 3 months ago.

Red:
Select cell A2 > Conditional Formatting > New Rule > Use a formula
=AND(A2<>"",A2<=EDATE(TODAY(),-3))
Format: Fill Red > OK > OK

Green:
Select cell A2 > Conditional Formatting > New Rule > Use a formula
=A2>EDATE(TODAY(),-3)
Format: Fill Green > OK > OK

[ranman256]

here: cell A1 = today()
eval date is in G3
#days since, h3=DAYS(A1,G3)
set conditional format on h3 to red if h3>90, green if <90

[rombouya]

Thx, this was what i was searching for!

[AliGW]

Welcome to the forum! Please take a moment to re-read forum rule #1 regarding thread titles and use better ones in future. Thanks!

• Use concise, accurate thread titles.
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.