Forum Discussion
Gumzz212
Feb 29, 2024Copper Contributor
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 ye...
- Feb 29, 2024
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)
Rodrigo_
Feb 29, 2024Iron Contributor
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)