Thread: Can I get Excel to automatically BOLD dates 30d before expiration?
View Single Post
  #3   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 expiration?
Try conditional formatting

(Steps in xl2003)
Assuming dates running in A1 down (real dates are presumed)
Select col A (A1 active)
Click Format Conditional Formatting
Under Condition 1,
Formula Is: =AND(A1<"",A1-TODAY()<=30)
Format Font tab Bold OK
OK out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Donna" wrote:
I am new to Excel (obviously), and I have created a simple worksheet that
contains numerous dates. I wish to have the dates become bold when they are
to expire within 30 days. Is there a formula for that purpose?

Thanks...
Reply With QuoteReply With Quote