I've looked at a few things (this link, WA's Colorize a cell in Google Spreadsheets based on cell data, and this link), but haven't been able to quite get the behaviour I want in Google Sheets. What I want to do:

  1. Enter six characters (e.g. 00B6FF) into a cell without adding a # before them
  2. Have the cell to the right of that cell get coloured with the corresponding hex value.

I'm a designer, so not too savvy with the scripts, but I'm up for trying. Tried each of those links above, but the only one I got to work was the gist one, but I don't want it colouring the text.

Can anyone help me figure out how to do this?

  • I'm sorry but I had to delete my answer. Apparently, you can't change the background color of a cell as easily as I thought. It can't just be triggered by completing a value in another cell. You need to script a function and then trigger that function from a button on your sheet! Feb 23, 2017 at 17:57
  • Questions should be self contained. Please add the relevant content of the external sources, in this case, the gist code. Mar 28, 2017 at 9:53

1 Answer 1

  • This is the same answer than this other webapps.stackexchange.com/a/118815/88163 and the same comment that I made to it almost one year ago it still applies, "The referred extension can't be installed" Jun 15, 2019 at 21:45
  • installed today on alt acc and pic taken
    – user0
    Jun 15, 2019 at 21:51
  • Here are two issues. It's possible that one user can install an add-on and another can't, like limiting an add-on to certain countries, maybe it can be installed by Google regular accounts but not by G Suite accounts. Unfortunately the add-on install page doesn't mention any restriction. The other issue is regarding deleting an answer and posting again exactly the same content as answer to the same question. IMHO that should not be allowed as its looks as some sort of cheating. Jun 15, 2019 at 22:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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