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
Could you please give an example showing how to do the same exact thing only with the coloring of TEXT within a cell instead of coloring the background of a cell? CVWISMO
Unfortunately, I could not get the original solution to work.