Home » Forums » Open Source Learning Center » Question and Answer

Help with formula

Submitted by jlbf9090 on 17 September, 2014 - 14:08

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

‹ Pulling data from 2 non identical lists using a unique identifier - help! Extract Data from large file ›
»

Hi jlbf9090, I answered this

Submitted by mec1981 on 18 September, 2014 - 02:19.

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

»