Hi Phil-

One Option, there are others- In FormatConditional Formatting:

Cell Value is Less than or equal to =NOW()-7

Set your cell format specs to how you want the date to display.

HTH |:)


"Phil" wrote:

I maintain a "DEMO" spreadsheet that has a return date for the product of
mm/dd/yyyy. I would like to have that highlighted 7 days before the product
is due back. Any help with a formula would be greatly appreciated!! Also, is
there an ability to format so it also emails me a notice?

Thanks,

Phil Hamm