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?

Try =$E2 < (TODAY() + 7)
more information on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

if you tried = DATE + 7
on the worksheet you would see that it is invalid
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I'm trying to change the colour of rows based on how close th deadline
is. The deadline date is in column E

I've been trying

=IF $E2<DATE+7

So, if the date in E2 is 7 days away or less, then apply conditional
formatting.

Excel won't accept this, though

 

[Bob Phillips]

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


--

HTH

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

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

Try =$E2 < (TODAY() + 7)
more information on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

if you tried = DATE + 7
on the worksheet you would see that it is invalid
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I'm trying to change the colour of rows based on how close the deadline
is. The deadline date is in column E

I've been trying

=IF $E2<DATE+7

So, if the date in E2 is 7 days away or less, then apply conditional
formatting.

Excel won't accept this, though.