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?