Conditional formatting with date in formula

Question

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 ?

Answer 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)