Forum Discussion
Coloring date for the day after tomorrow
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)
use this conditional formatting formula for your 'day after tomorrow's date'
=TODAY() + 2 = A2Assuming 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)
12 Replies
use this conditional formatting formula for your 'day after tomorrow's date'
=TODAY() + 2 = A2Assuming 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)
