SOLVED

Conditional Formatting Two Columns

New Contributor

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

1 Reply
best response confirmed by MShelnutt (New Contributor)
Solution

@MShelnutt 

=AND($J2<TODAY(),$K2="In Progress")

You can try this rule for conditional formatting.

=$J$2:$K$22

This is the "applies to" range in the example. 

cf.JPG