Copy colored cell to a second page

[shellie77]

Okay, I have revamped a spreadsheet at work where we keep track of ou
employees time, two weeks at a time. On page 1, I have all of th
employees in alphabetical order. The second page, they are groupe
together by what job they are doing. On page 1, I color the cell
depending on what kind of time is put in: vacation, OT, etc... I hav
figured out how to get all the cells on page one to copy over to pag
two, but the cell color does not copy over. How can I get the cells o
page 2 to change color as I change the color of the employee's time o
page 1? I am not too familiar with programming, so if I have to enter
formula, you are going to have to spell it out for me.

Any help you can give would be greatly appreciated

 

[SriramNA]

Instead of coloring the cells directly, try using a code for the kind of
time, e.g. 1 for vacation, 2 for OT etc.

Then use conditional formatting.

--
Sriram

"shellie77" wrote in message

Okay, I have revamped a spreadsheet at work where we keep track of our
employees time, two weeks at a time. On page 1, I have all of the
employees in alphabetical order. The second page, they are grouped
together by what job they are doing. On page 1, I color the cells
depending on what kind of time is put in: vacation, OT, etc... I have
figured out how to get all the cells on page one to copy over to page
two, but the cell color does not copy over. How can I get the cells on
page 2 to change color as I change the color of the employee's time on
page 1? I am not too familiar with programming, so if I have to enter a
formula, you are going to have to spell it out for me.

Any help you can give would be greatly appreciated.