How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask NewITZone Your Own Question
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

i have a question about microsoft excel. I have two sheets

Customer Question

i have a question about microsoft excel.

I have two sheets whose cells are color coded depending on the status of the persons within my department.

The first sheet has the color count vba code in a module and works fine.

What i need to be able to do is as the color of a cell changes on sheet 1 then the associated cell (not the same line or row in most instances) on sheet 2 will change to the same color.

Is there any VBA code i can use to do this or any other method you can think of?

Many thanks in advance

PO (AWT) Ayling
Royal Navy
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  John D replied 5 years ago.

This that can be done with vba code but it requires getting your file, understanding the details then setting up the macro which is a fairly long process


Customer: replied 5 years ago.
,I have not completed the data in put yet so should i send a msg when i have?What details do you need?
Expert:  John D replied 5 years ago.

You can send a sample file


Customer: replied 5 years ago.
i cant im working from a military server
Expert:  John D replied 5 years ago.

Ok in that case bookmark this page and come back when you're ready



Customer: replied 5 years ago.
with referance to your sample file request, can i email it to your account as i cant seem to attach it to the reply page??


Expert:  John D replied 5 years ago.

Hi again


You can go to and upload the file using the Browse button (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.


If the file has sensitive information let me know before you upload it