Add Cell Fill Colour Based on Hex or RGB

[Beth ten Have]

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?

[#2]

@Beth ten Have 

For the desktop version, if manually,

Not sure about Excel for mobile

[#3]

Thanks, but I need the colour for 160 rows of data, so I was hoping that there was a less manual method!

[#4]

@Beth ten Have 

HEX code is different for each row, for each cell of each row, or the same for all rows or what?

[#5]

Hi@Beth 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?  

[#6]

@NehaS50 

Without VBA it's not doable.

The nearest solution would be the feature "conditional formatting".

JC

[#7]

@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
• Column C: Use formula {=image(@[LINK])}

voila

[#8]

This is amazing!!!! @CVWISMO 

Thank you so much!