Conditional Formatting help
 

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?

Conditional Formatting help
 

=AND(E7<"",(TODAY()=DATE(YEAR(E7)+1,MONTH(E7),DA Y(E7))))

=AND(E7<"",(TODAY()=DATE(YEAR(E7)+1,MONTH(E7),DA Y(E7))))

--
__________________________________
HTH

Bob

"Dolphin" wrote in message
...
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?

Conditional Formatting help
 

Thanks, Bob. That worked great!

"Bob Phillips" wrote:

=AND(E7<"",(TODAY()=DATE(YEAR(E7)+1,MONTH(E7),DA Y(E7))))

=AND(E7<"",(TODAY()=DATE(YEAR(E7)+1,MONTH(E7),DA Y(E7))))

--
__________________________________
HTH

Bob

"Dolphin" wrote in message
...
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?