nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Change cell color using color values in cell

hfederovich

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?

Accepted answers

txnelson

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

All comments

txnelson

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

hfederovich

Yes

hfederovich

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.

txnelson

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