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)



1 Reply
best response confirmed by MShelnutt (New Contributor)


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

You can try this rule for conditional formatting.


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