View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scott scott is offline
external usenet poster
 
Posts: 577
Default Conditional Formatting in Excel 2007


Conditional Format Help

Due date in cell I16

Date in cell A4 shows when something was last done.

I want to make a conditional format in cell A4 if the cell value of A4:

1. Is ten days or greater of I16 to make the cell blue
2. Is between 5 to 9 days of I16 to make the cell yellow
3. Is between I16 and 4 days of I16 to make the cell red

Thanks in advance