OK...I'm a rookie at this kind of thing......I'm missing something here....

Column "I" has a heading of "DATE DUE BACK" -- I would like to have I2 thru
I90 to turn RED 7 days before the date in that cell. I keep looking/typing
the formula in and trying differnet "minus # of days" to see if it
changes.....mmmmm........confusion on my end - IDEAS???

Thanks much!!!!

Phil

"Bob Phillips" wrote:

Use a formula of

=AND(A1<"",A1TODAY()-7,A1<TODAY()+1)

to avoid blanks and future dates


--
HTH

Bob Phillips

"CyberTaz" wrote in message
...
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