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 Hi...
=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.
=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.