Set up conditional formatting in dates, with additional variants

Carmen Allende

I know how to set the conditional formatting to have a date cell turn red when the task is due in the next X days (for example). But is there a way to do it only if the Status (another column) is not in "Complete"?

So something like: If Status is "In progress", "In review", or "Not Started", AND Due Date is in the next 2 days, turn Due Date column red.

Is this possible?

Ray Lindstrom

@Carmen Allende,

Hello,

Yes, this is possible.

1.) Create your conditional format rule with your first condition.

2.) Use the dropdown arrow next to the conditional format rule to select "Add Condition (AND)"

3.) Add your second condition

Ray Lindstrom

@Carmen Allende,

Hello,

Yes, this is possible.

1.) Create your conditional format rule with your first condition.

2.) Use the dropdown arrow next to the conditional format rule to select "Add Condition (AND)"

3.) Add your second condition

Carmen Allende

Thank you Ray!!