I am trying to set up a spread sheet that has Due dates in column A and Completed dates in column B.
I have conditional formatting to change the due dates to yellow 30 days before they are due and to turn red when they are past due.
What I am now wanting to do is have the conditional format stop if the due date is after or the same day as the completed date.
I tried another conditional format =A1>=B1 and formatted it to go back to original cell fill color, but when the B1 is blank A1 does not revert back to the other conditional formatting for the red and yellow colors.
I think the problem is when the cell B1 is blank it makes the conditional format true and A1 would be greater than B1, but I don't want the blank cell to make the condition true.
Any help would be greatly appreciated.
Bookmarks