date - 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 ?

标签： dategoogle-sheetsgoogle-sheets-formulags-conditional-formatting

Answer 1

在条件格式中选择自定义公式并将其输入到字段中：

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

或者如果您有非美国语言环境：

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