I am having a Master engg roster sheet for manpower scheduling and another engg sheet that is shared with everyone.

Master engg roster ( not shared with people)

engg roster ( shared with people)

I am having some cells in the Master engg roster which I don't want people to see, so I use importrange to import data from the master engg roster ---> engg roster.

I work on the master engg roster to make the changes in the roster of people.

It looks like this.

enter image description here

I highlight the changes for my reference.

Since I use import range to import the data in another sheet which is shared with others it dose not copy the colors.

It would be better if the colors are also imported so that the staff viewing the roster can easily see the changes in his roster.

This can be done in two ways but I do not know how to do it.

Method 1: somehow automatically import the colors from the master sheet to the shared sheet.


Method 2: in the shared sheet make a script to highlight a change automatically from original data in sheet.

Please help.

  • those colors are generated or you set them manually? – user0 Feb 12 '19 at 12:45
  • I set them manually. – user7585870 Feb 12 '19 at 17:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.