Conditional Formatting based on deadlines

[madbloke]

Both suggestions work well, however the conditional formatting i
applying if the cell in column E is blank. I want the blank rows t
stay white. How do I make it do that?

 

[Bob Phillips]

=AND($E2<>"",$E2 <(TODAY()+7))


--

HTH

RP
(remove nothere from the email address if mailing direct)