Cell format rule

Ask for Help Formulas
1

Hi.

I am trying to format a cell if the entered date is < TODAY().
This basically works. But it throws an error on empty cells, as the date can’t be compared. This changes the call format to an “error format”
Can this be prevented?

Curernt formula I tried:
AND(NOT(ISNA($Warnung_ab)) , $Warnung_ab < TODAY())

2

Hi Robert!

You can simplify this to:

$Warnung_ab and $Warnung_ab < TODAY()

The formula will first check if a value exists in the Warnung ab column then will compare to TODAY().

This will return a blank value if no value exists in Warnung ab.

Thanks,
Natalie

3

Brilliant. This worked.
Thanks a lot!

1 Like