Conditional formating

  • Thread starter Thread starter Renee Cole
  • Start date Start date
R

Renee Cole

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.
 
Hi,

Try this
Format|Conditionl format
select formula is
enter the formula
=A1<TODAY()-365
Mike
 
Great! Now how do i copy this conditional format rule for 130 employees for
a given task without having to set up a new rule for each cell?
 
Sorry to bug again, but I'm not sure I'm clear. So if i have 130 employees
with 30 different training task (all with a variety of dates completed), it
seems like in the formating formula that you have to select an individual
cell to assess a date. If I select all of the cells in just one row and then
go to formating, won't it select the criteria based on the date in the first
cell? Is there a way to say B5:CZ5? I was hoping to not format each
individual cell since most dates are different (3900 cells) for each employee.

Thanks again,
 
Back
Top