Home » Blogs » jlbf9090's blog

Formula issue

Submitted by jlbf9090 on 10 September, 2014 - 00:36

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

»

Formula issue resolved

Submitted by jlbf9090 on 21 September, 2014 - 01:30.

removing the space between the quotation marks for null did the trick!

»

You need to add a little more

Submitted by mec1981 on 17 September, 2014 - 02:20.

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

»