Conditional Formatting based on deadlines

madbloke · Nov 2, 2004

Excellent! Thanks! My brain gets confused between what you can use i
formulas and what can be used in VBA.

David McRitchie · Nov 2, 2004

NOW() has a date and time component
TODAY() has only a date component

Alex Delamain · Nov 2, 2004

Ok, incorporating Dave McRitchie's Today() in place of Now()

=AND(+$H7<=TODAY()+7,+H7>0