I want cells in Column M to get a color if date (in that cell) has reached 90 days and if Column A has the value "Onvoltooid"
I selected the column range and clicked on the item: Conditional Formatting. Here I set:
Format Cells if...
Date is
exact date..
then I wrote: TODAY() - DATE() > x
//x = 90 days for test x = 1 day
and I selected a color.
But it does not work. is TODAY() - DATE() > x
even correct notation?