View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
billz billz is offline
external usenet poster
 
Posts: 7
Default Conditional formatting by day of the date in Excel 2003

I use a worksheet for each month to track my bills.
I enter a due date of each bill in Month Day Year eg. 03/14/01.
I would like for my date that I would enter to change color if the Day is
less than the previous date entered.
eg March tab has card due on 03/14/01, and in April the date may be 04/10/01.
I would like April date to be Red, for example.

Can this be done?
Thanks for your responce.