2 years ago

#64676

test-img

TheLebDev

Google Sheets: Cell color hex value to be fetched from another cell's value

I have a Google Sheets file that contains 2 sheets:
L1: A listing of my expenses (screen shot) Expenses listing

As you can see, there are two columns named Tag #1 and Tag #2. These are linked to a list of tags I've created.

Color Palette: This sheet represents the color coding I've adopted across my file. (screen shot)

Color Palette sheet

I'd like to change the color of Tag #1 and Tag #2's cells to match their tag's color in the Color Palette sheet.
I understand I could do it using conditional formatting, but is there a way to link the color I pick in the conditional formatter directly from the Hex Code column present in the color Palette sheet?

google-sheets

hex

conditional-formatting

drive

0 Answers

Your Answer

Accepted video resources