View original (French)

Color cells in excel function result calculated hex 000000 to FFFFFF

Achelemix Posted messages 4 Status Member -  
TheSavior2017 Posted messages 1 Status Member -
Hello
I want to color an Excel cell based on a given hex value between 000000 and FFFFFF.
So I should be able to use all colors without doing it manually.

For example, #BD56A0
Hexadecimal decimal in RGB
BD56A0 12408480 213 106 72
And we get a sort of red that leans towards brown.
But I want the cell to take the color directly from the value I input or calculate, without being forced to do it manually.
The function that colors based on a value does not use the entire color palette, only 2 or 3 colors with their intermediate shades.
I want to be able to use any color from the palette.
Thank you

1 answer

Answer 1 / 1
cs_Le Pivert Posted messages 8437 Status Contributor 730
 
Hello,

See this in VBA with a downloadable workbook:

https://silkyroad.developpez.com/VBA/ConversionCodesCouleurs/

After reviewing this site, here is the code to color a cell: 

 Range("A1").Interior.Color = &HF378E0 'Hex Value


@+ The Woodpecker
1
TheSavior2017 Posted messages 1 Status Member
 
hello,
I know it's not exactly that, but maybe by tinkering a bit with the process, you can manage to do what you're looking for?

https://www.ablebits.com/office-addins-blog/2013/10/18/change-background-color-excel-based-on-cell-value/

in VBA you also have this script:

https://stackoverflow.com/questions/10455366/how-to-highlight-a-cell-using-the-hex-color-value-within-the-cell

#bd56a0 is more like a purple, right?

https://www.crazy-colors.net/en/hex/bd56a0

keep us posted! :)
0