T
The moderator
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
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