User Profile
MShelnutt
Copper Contributor
Joined Mar 24, 2021
User Widgets
Recent Discussions
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) TIASolved800Views0likes1Comment
Recent Blog Articles
No content to show