CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaconditional-formatting
Leos Literak
Leos Literak

Reputation: 9474

Conditional formatting in Google sheet for finished/due tasks

I have built a simple task tracker in Google sheet.

There is column B handling the status (In progress, Done) and Due date column C.
I have created to formulas: exact match for B that sets the color to green and date before today for C that sets the red color.

The problem is that they work independently. Red color is displayed for C even when B is Done.
And each rule highlights different column.

enter image description here

Text is exactly Done

enter image description here

Date is before =today()

enter image description here

How to make the date formatter ignore the past dues when the task status is set to Done?

Upvotes: 2

Views: 699

Answers (1)

marikamitsos
marikamitsos

Reputation: 10573

You mentioned

exact match for B that sets the color to green and
date before today for C that sets the red color

Try the following formula under Custom formula is

=AND(C3<TODAY(),B3<>"Done", C3<>"")

enter image description here

(Do adjust ranges to your needs)

Upvotes: 2

Related Questions