I am really unsure how to set conditional formatting rules using formulas that reference more than one column or row.
This is a part of the project timeline I am putting together:
I want to have a conditional formatting formula that changes the “Days Overdue” cell red if "Days Overdue" is greater than 0, AND “Complete” is unchecked. I am having lots of trouble doing so.
I tried many variations, including the following:
Please note “Dates Overdue” is a formula column: