Conditional formating

[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.

 

[Mike H]

Hi,

Try this
Format|Conditionl format
select formula is
enter the formula
=A1<TODAY()-365
Mike

 

[Renee Cole]

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?

 

[Renee Cole]

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,