To sync a Google spreadsheet with several other spreadsheets in the same series and at the same time have unique colors for each data value in each sheet.

In this example, I am using a Google Spreadsheet bar that I have designed from my comment software "shareable comment tool".

I use the original value from the spreadsheet named original and sync this with duplicate spreadsheets in the same series by using 3 pieces fx function in the respective spreadsheet except in the original.

Fx functions:

 

1. =original!A3

2. =orginal!B3

3. =orginal!C3
   

For example, I enter the functions in the duplicated spreadsheet sheets in cells A3, B3, C3. After this I change the color in all the bars. 

The result of this is that when any of the values in the original spreadsheet is changed, it is also changed in all other duplicated spreadsheets where each of these has a unique color/ design. 

 

So what is the point of this?

First, if you have some marketing data that you designed in Google Spreadsheet to be shared with multiple others and to be embedded on multiple web pages, users may want the data to be uniquely colored to match a web page's layout.

Second, by using these simple fx functions can data information owners easily update an unlimited number of different spreadsheets in a unique color/ design in the same series by only changing input values in the original Google spreadsheet sheet (in one spreadsheet).

 

Simple and powerful.   

 

 

 

---

Other articles:

• Manipulate number value automatically based on set interval.
• Interface example and functions - Shareable Comment Tool
• Digital Marketing - Layout in a Google Spreadsheet
• How to make a layout in Google Spreadsheet with associated automatically countdowns based on the break date/ time.

--

Best regards,     Karl-Johan Gyllenstorm Ring | 08-55920699 hemsida  |  gyllenstorm.joomla.com kgyllenstorm@gmail.com  |  Köpmansgatan 109