Forum Discussion
Solved
Add Cell Fill Colour Based on Hex or RGB
Is it possible to fill a cell with a colour based on either the hex code or the RGB values of that colour (they would be in neighbouring cells in the same row) without using VBA?
Beth ten Have I just figured out a solution here for those still scratching their heads.
Make a table with:
- Column A: Insert your hex codes and name the column "HEX"
- Column B: Name this column "LINK" and use formula:
- {="https://www.colorhexa.com/"&[@[HEX]]&".png"}
- Make sure to remove the braces before and after the above formula
- {="https://www.colorhexa.com/"&[@[HEX]]&".png"}
- Column C: Use formula {=image(@[LINK])}
voila
- Thanks, but I need the colour for 160 rows of data, so I was hoping that there was a less manual method!
HiBeth ten Have , I had a similar task and was wondering if you found a way to fill adjacent cell with the colour matching the hex code entered in the same row?
HEX code is different for each row, for each cell of each row, or the same for all rows or what?
