Copy colored cell to a second page


S

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
 
Ad

Advertisements

S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top