Thread: conditional formating on dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
  
Posts: 9,101
Default conditional formating on dates
try this

=(G1-TODAY()<30)

"Margotbf" wrote:

Hello,

I have to track expiry dates in a datasheet. Actually, I'd like the expiry
date field to change color 30 days prior to the expiry date written in the
field. Let's say the expiry date is oct 24 2008, I want the field to change
color on sept 25 2008. The date format chosen is 24-oct-08, does it matter?

Thanks!

--
Margot
Reply With QuoteReply With Quote