Due date - change cell color
I am using excel to track calibration dates. I would like to have the cell
or cell text change color based on the calibration due date.
For example:
Last Calibration Date Cycle Due Date
01/01/09 6 month 6/1/09
03/01/09 3 month 6/1/09
02/01/09 3 month 5/1/09
When the Due date is within one month I would like the Due Date to display
yellow. When the due date is within one week or less the Due Date should
display red.
TIA
|