CODEWITHSUNDEEP
dategoogle-sheetsgoogle-sheets-formulags-conditional-formatting
Porto77
Porto77

Reputation: 37

Conditional formatting with date in formula

I want a cell to be colored if the present day is equal to a date I wrote into a formula.

So I created conditional formatting with this special formula, for the F8 cell for instance:

TODAY()=DATE(2020,4,3)

Color green in the background

It doesn't work. And I really don't know why...

Any idea ?

Upvotes: 1

Views: 36

Answers (1)

player0
player0

Reputation: 1

in conditional formatting select Custom formula and enter this into the field:

=TODAY()=DATE(2020, 4, 3)

or if you have non-US locale:

=TODAY()=DATE(2020; 4; 3)

Upvotes: 1

Related Questions