Conditional formating
Hi,
Try this
Format|Conditionl format
select formula is
enter the formula
=A1<TODAY()-365
Mike
"Renee Cole" wrote:
I have a spreadsheet containing training completion dates for numerous tasks
for each employee. Since the training is done annually, I want the cell to
turn red once the year expires so that the supervisors reviewing the
spreadsheet can notify the employee their next annual training is due.
--
R Cole
|