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 behavior 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 colored 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 coloring 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 at 23:10

Your Answer

 

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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