View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_4_] Sheeloo[_4_] is offline
external usenet poster
 
Posts: 225
Default Conditional formatting--different formatting depending on cell con

Choose FORMULA IS and enter the formula
=AND(A1<"",(A1-TODAY())<15)

It will higlight cell A1 if it contains a date which falls within the next
15 days (including dates in the past)

If you want to highlight dates only in the next 15 days use
=AND(A1<"",(A1-TODAY())<15,(A1-TODAY())0)

"Tammy S." wrote:

I would like to format a date cell when the date will expire in 15 days. If
there is no date, I don't want any formatting. How can I set the formatting
to meet both of these conditions?