Forum Discussion
Solved
Conditional Formatting Two Columns
Hello, I have two columns in my spreadsheet (J and K)= Due Date and Status respectively.
Status is a drop down with choices of In Progress, Completed, or Cancelled.
I want to set a Conditional Highlight so when the due date has passed AND the Status is In Progress, the Due Date cell will turn pink.
This is what I have tried, but it doesn't like the formula:
=IF(AND(J2<TODAY()),(ISTEXT(K2), "In Progress","")),TRUE, FALSE)
TIA
=AND($J2<TODAY(),$K2="In Progress")You can try this rule for conditional formatting.
=$J$2:$K$22This is the "applies to" range in the example.
1 Reply
=AND($J2<TODAY(),$K2="In Progress")You can try this rule for conditional formatting.
=$J$2:$K$22This is the "applies to" range in the example.