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.
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.