try
selecting all
conditional format
formula is =and($G1<today()-7,$G1 30000)



"tomklem" wrote:

How do I highlight a cell that has a date older than 7 days from todays date?
ex. column G has the date I passed out the invoice to be signed off on. I
want to highlight all those that have been out for more than 7 days.

I tried Formula is =G:G<TODAY()-7 but that highlights every date no matter
if it is older than 7 days or even future dates.

If I want it to look really nice I would like it to highlight the entire row
that date fall in.