Hello,
I try to put a condition:
I want if the date written in cell 02 is + 10 days I want to highlight it.
O2: 2021-12-28
Today it shall be colored.
If O2: 2021-01-07 I want it to be colored when we are in 2021-01-17
Anyone knows how I can do this? Google tell me: O2 < TODAY()-10 but this does not work... Especially as the value will be "2021-01-07" - 10 = 2020-12-28 which will highlight it.
I try to put a condition:
I want if the date written in cell 02 is + 10 days I want to highlight it.
O2: 2021-12-28
Today it shall be colored.
If O2: 2021-01-07 I want it to be colored when we are in 2021-01-17
Anyone knows how I can do this? Google tell me: O2 < TODAY()-10 but this does not work... Especially as the value will be "2021-01-07" - 10 = 2020-12-28 which will highlight it.