conditional formatting between 2 columns, same row

7eaven

is there an ability to set a conditional format based on two columns in the same row:

completed (column) date is later than the due (column) date – the cell turns red

completed date entered is before (or after) today's date

Mike Wilday

Yes, there is! Thought its kind of hidden. After you set up a conditional formatting you have to click on the arrow to the left of the condition and add another condition. See Screenshot.