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:

`(thisRow.[Days Overdue]>0)AND(thisRow.Complete=false)`

`(thisRow.[Days Overdue]>0)AND(thisRow.Complete.IsBlank())`

Please note “Dates Overdue” is a formula column:

`if(Days(Today()-thisRow.Due)>days(0),(Days(Today()-thisRow.Due)),0)`

Any suggestions?