Forum Discussion

Copper Contributor

Feb 29, 2024

Solved

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...

excel

Excel for web

Formulas and Functions

Rodrigo_
Feb 29, 2024
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)

Gumzz212

Copper Contributor

Feb 29, 2024

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

Rodrigo_

Iron Contributor

Feb 29, 2024

yes.

Gumzz212
Copper Contributor
Feb 29, 2024
Rodrigo_
it's a bit strange the formula doesn't work
TRY.xlsx13 KB
- Rodrigo_
  Iron Contributor
  Feb 29, 2024
  Gumzz212
  here's the corrected formula:
  
  TRY.xlsx17 KB
  - Gumzz212
    Copper Contributor
    Jun 14, 2024
    Hi bro could you help on another work? could we now make a cell light up red when it's not filled based on another cell that contain date
    and I wanna make the difference is about two days before
    Example the cell date is 14/06/2024 when the subject cell is not filled on 12/06/2024 it turns red and when it filled its just back to normal