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
|