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
When i have done this on my work computer it comes up as BLOCKED!. I then also tried it on my personal excel to see if the problem was with the external link being blocked and it then came up saying FIELD! and then i tried again and it said BUSY!.
Each time i tried re entering the formulas and then it swaps to saying #VALUE!
Does anybody know what the issue is or how to correct it/ what I might be doing wrong?
I had the same issue until I removed the # from my hex codes, at which point it worked just fine.