Help with formula

I could really use an expert's help. What am I doing wrong?

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=" ")

Hi jlbf9090, I answered this

Hi jlbf9090,

I answered this query on the blog site but notice you have also posted it in the Q&A forum a few times. below is the answer I previously posted:

You need to add a little more to the function and remove the space between the quotation marks as follows:

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

then in the format option select Fill and choose red

Regards
Mark