Google-sheets – Conditional Formatting color if today minus cell date is more than 90 days

conditional formattinggoogle sheets

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?

Best Answer

The solution is a multi-criteria formula.

In my case you want both criteria to be true.

Use this: =and(criteria_1, criteria_2) in the Conditional Formatting functionality. Use this as the 'custom formula' entry. 

=AND(TODAY() - M3 > 7, A3 = "Onvoltooid")

this formula says:

Criteria_1: if date of TODAY minus Date-value in column M (from row 3) is higher than '7' days.

AND

Criteria_2: The value of that same row on another column (column A, row 3) is "onvoltooid" (which is a specific value)

Then give specific color to the selected range.

Related Topic