Either select all the cells before you apply the CF,
or use the format painter,
or copy and Edit/ Paste Special/ Formats.
--
David Biddulph

"Renee Cole" wrote in message
...
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?
--
R Cole


"Mike H" wrote:

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