Hello,

I have a worksheet titled Sample on which cell B5 is the due date and cell B4 is the completion date. I want to use conditional formatting on a separate worksheet that displays a dashboard of the project in which a cell will fill red if the due date is today or has passed but the completion date is blank. I'm doing something wrong with the formula but cannot figure out what. Any help would be greatly appreciated.

=AND(TODAY()>=Sample!B5, Sample!B4=" ")