Simple spreadsheet.
I have data in A1:F50
Column E is Due Date
Column F is Completed Date
I selected A1:F50
Conditional Formatting->New->Format values where this formula is true
=AND(NOT(ISBLANK(E1)),NOT(ISBLANK(F1))) <- If both E1 and F1 contain data (prefer date but don't know how to check for it) then fill row with color
Applies to =$A$1:$F$50
You would think this is simple and straight forward. However, the only column that fills is column A.
Bookmarks