In my exercise tracking spreadsheet, I want blank cells in columns
B:O highlighted if column
A is today's date, and the cell itself is blank. I have tried this:
=AND(ISBLANK(B3),$A:A=INT(NOW())) applied to range
B3:O1000, but it doesn't highlight anything. Here's a sample sheet For the second term of the
AND(), I've tried
INT(NOW()), $A:$A=INT(NOW()) and
A3=INT(NOW()), all with the same result: formatting not applied.
A, the formula
=A:A=int(now()) does apply the intended format. If to the larger range, I just apply
=ISBLANK(B3) without checking the date, all the blank cells are formatted. If I put the
AND formula into a cell with references to today's date in column
A and any blank cell, it returns
JPV's answer solved the problem perfectly - yesterday. Today, with the new conditional formatting custom formula unchanged, it's back.
Blank cells in today's row aren't formatted in Safari (7.1.3 (95188.8.131.52), Chrome (Version 41.0.2272.89) or Firefox 36.0.1. I'm using a MacBook Air 13", OS X 10.9.5 4GB RAM, 1.4 GHz Intel Core i5.
I'm tempted to think Google has a server-side problem, because some of my earlier unsuccessful efforts did show the intended formatting on my iOS 7 iPhone - sometimes.
Can anyone explain or duplicate this problem?