Coloring date for the day after tomorrow

[Gumzz212]

Hi all, I hope you guys had a good day

I'm trying to organize my work here, I already organized it so I could tell when the task is near by changing conditional formatting to tomorrow, today, and yesterday
However I want to be a little bit organized again, could we do color changing the day after tomorrow? just only one day after tomorrow, I always ran into the problem that color changing changes all day after tomorrow
Example: today is 29/02/2024
tomorrow is 01/03/2024

the day after tomorrow is 02/03/2024 (this day I wanted to change color for only this day, not for all day that after tomorrow)

[#2 · Accepted solution]

@Gumzz212 

use this conditional formatting formula for your 'day after tomorrow's date'

=TODAY() + 2 = A2

Assuming that your current date is on cell A2.
This rule will only affect the day after tomorrow, not any other dates.

you could also use this as reference: Change cell colors based on date (conditional formatting)

[#3]

and how to make the A2 cell is auto update?
is the function "=TODAY()" is right?

[#4]

yes.

[#5]

@Rr_ 

it's a bit strange the formula doesn't work

[#6]

@Gumzz212 
here's the corrected formula:

[#7]

for now it's work, let's hope tomorrow works to
thanks