topic Re: Change cell color using color values in cell in Discussions

Change cell color using color values in cell

hfederovich — Sat, 10 Jun 2023 23:30:51 GMT

I have a column with different hex color codes and I would like to color each individual cell with the color of that cell's hex code. Is this possible?

Re: Change cell color using color values in cell

txnelson — Thu, 27 May 2021 19:04:51 GMT

I am assuming the hex values are relatable to RGB values?

Re: Change cell color using color values in cell

hfederovich — Thu, 27 May 2021 19:42:46 GMT

Yes

Re: Change cell color using color values in cell

hfederovich — Thu, 27 May 2021 19:45:26 GMT

I found another community post on how to change them to RGB but really what I don't know how to do is then change the cell color using the value/code in that cell.

Re: Change cell color using color values in cell

txnelson — Thu, 27 May 2021 19:56:34 GMT

Here is the basic structure to use.....I don't know the specifics of your hex column so you will have to do that work.

dt:target col refers to the column name of the cells you want colored

names default to here(1);
dt=current data table();

for(i=1,i<=nrows(dt),i++,
	r = hex value converted to decimal;
	g = hex value converted to decimal;
	b = hex value converted to decimal;
	dt:target col << color cells( rgb color( r, g, b ), i );
);

The various functions are all documented in the Scripting Index under the Help pull down menu