It’s World Statistics Day! To honor the theme of the day, the JMP User Community is having conversations about the importance of trust in statistics and data. And we want to hear from you! Tell us the steps you take to ensure that your data is trustworthy.
Choose Language Hide Translation Bar

Set background color in column header/column names

Often I work with tables that have many columns. Scrolling back and forth to get to a certain area of the table can be inefficient if I have to stop periodcially to see where I'm at and then try to remember if I've gone too far or not far enough.


It would be wonderful to be able to assign colors to the background of column names. This way I can color-code sections of the table and quickly find what I want. Being able to assign a color to a group of columns would also be useful. It would be super great if the colors would also appear in the column window on the left also.


Thanks much and keep up the great work.

Tracking Number:

Defect ID: S1553854

Super User

You can already do that 


Names default to here(1);
dt = open("$SAMPLE_DATA\Big");
Column(dt, "height") << Color Cells( "Red" );

Or click a column header to select the whole column and right click the values.  Go to color cells and choose your color. 


I like to do this with column groups and have entire groups be a color.  

Names default to here(1);
dt = open("$SAMPLE_DATA\Semiconductor");
cols = dt << Get Column Group("Processes");
For(i=1, i<=nitems(cols), i++, 
	cols[i] << Color Cells("Light Blue");



Level III
Hi Vince,

Thanks for the response.

My desire here is to color just the headers, not the cells. I do use cell colors for specific cells, but for me coloring all the cells in a column group is too much.

Right now, I also use a blank column with the cells colored in to delineate boundaries between groups of columns but that’s kind of clunky.
Level IV
Plus one Kudos to the idea of coloring the Column HEADERS, because I often use Value Colors and Color Gradient Column Properties for easily identifying outliers, etc.