Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
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 Class.jmp");
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 Capability.jmp");
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.