Thread: Can I get Excel to automatically BOLD dates 30d before expiration?
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Can I get Excel to automatically BOLD dates 30d before expirat
.. when the expiration date is less than 60 days away, but
greater than 30 days away.

Think you could put it in CF's Condition 2 as:
=AND(A1-TODAY()30,A1-TODAY()<60)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote