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! – BrettFromLA Feb 23 '17 at 17:57
  • Questions should be self contained. Please add the relevant content of the external sources, in this case, the gist code. – Rubén Mar 28 '17 at 9:53
  • The referred extension can't be installed. – Rubén Oct 13 '18 at 23:10

Your Answer

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

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