View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RC RC is offline
external usenet poster
 
Posts: 39
Default Color field if date equals certain criteria

I have a list of dates in column A.
I have todays date in cell C1.
I want the date fields in column A to turn amber when they are equal to or
less than 15 days from todays date, then red when they are overdue.
Whats the formula for this please.