I have some experience using Excel's basic functions and thought it would be simple to create a conditional formatting rule, but I've discovered that it's a little more complicated than I anticipated. The rule would:
(1) check the date in B1; if the date is greater than or equal to today (TRUE)
(2) check to see if B2 is blank, if TRUE apply the conditional formatting cells B1:B3.
This Conditional Formatting rule would apply to $B$1:$E$9.
Note: The values in rows 2, 5 and 8 are limited to a 1 or -1.
In my screen shot example that's attached, the rule would apply to cells B1:B3 and D4:D6 because the dates in B1 and D4 are greater than today and B2 and D5 are empty.
I've tried =AND(TODAY()>=$B1,B2=""), but I'm not getting my desired results
I would appreciate your help letting me know what I'm doing wrong.