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/
- Make sure to remove the braces before and after the above formula
- {="https://www.colorhexa.com/
- Column C: Use formula {=image(@[LINK])}
voila
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/
- Make sure to remove the braces before and after the above formula
- {="https://www.colorhexa.com/
- Column C: Use formula {=image(@[LINK])}
voila
Fascinating! I hadn't come across the website and the sizing fields of IMAGE would also appear to open up interesting possibilities. On 365 the process does not require CSE array formulae and with Lambda functions, the approach can be further packaged
Worksheet formula
= COLORĪ»(HEX)Got a bit carried away!
Peter thank you so much, this will come in very handy !
- This was great. Thanks for sharing.