This question already has an answer here:

I am looking for a solution to change background and font color of a cell based on hex-values in another cell.

I am managing a google spreadsheet for an online basketball league. I have several sheets where there should be formatting based on the team name. For example, in the standings, the cell with the team name should appear in the teams colors. With conditional formatting I am able to say (sloppy way:) if team name = xyz -> background color = #aaaaaa, font color = #bbbbbb

I want to have a single sheet where I can "store" these team colors, so if a team has a change in their team art, I don't have to change the conditional formatting on 100 different sheets, but just on a "color" sheet and everything gets updated after that.

So in the end, I want to have a sheet named "color" (or whatever) where I have 3 rows "team name", "color 1" and "color 2". If I change values in these cells, the whole document should update all cells where these team colors are used.

Anybody has a solution for this?

marked as duplicate by Rubén, serenesat, ale, Alex, jonsca Oct 22 '18 at 23:57

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


to play with hex values you need to add this add-on to your spreadsheet: https://chrome.google.com/webstore/detail/

  • 1
    "The Login with Google is temporarily deactivated for this app." Not able to use it. – jk31 Aug 20 '18 at 7:37

Not the answer you're looking for? Browse other questions tagged or ask your own question.