multiple condition test w/ date & ISBLANK()?

[KayG]

Hi everybody,

I am trying to use conditional formatting to decide if a date is 7 days older then todays date. the problem is that I have blank cells in this row that I do not want to change the format of until it has a date and the date is 7+ days old.

-kayg

[NBVC]

You'll need to use a formula to determine if cell needs formatting

e.g.

=AND(A1<>"",A1<TODAY()-7)