View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pat Pat is offline
external usenet poster
 
Posts: 210
Default Conditional Formatting

I have a column (J) with due dates expanding to 2015. I would like the due
date to change color when:
1. Due date is within 15 day of today's date (Yellow).
2. Due date is pass today's date (Red)
3. Due date is out pass 365 days (No color)

Can this be done?
--
pls