D
Dolphin
I have set the following conditions for my worksheet:
=(TODAY()>=DATE(YEAR(E7)+1,MONTH(E7),DAY(E7))) will shade red
=(TODAY()>=DATE(YEAR(E7)+1,MONTH(E7),DAY(E7))) will shade yellow
These conditions are set to each cell in the worksheet. The problem I
having is all the blank, or unfilled, blocks are now shaded red. I need them
unshaded if they are empty. What am I doing wrong or missing?
=(TODAY()>=DATE(YEAR(E7)+1,MONTH(E7),DAY(E7))) will shade red
=(TODAY()>=DATE(YEAR(E7)+1,MONTH(E7),DAY(E7))) will shade yellow
These conditions are set to each cell in the worksheet. The problem I
having is all the blank, or unfilled, blocks are now shaded red. I need them
unshaded if they are empty. What am I doing wrong or missing?