cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
EndersGame
Level I

Clear cell colors

How do I script to clear all cell colors (not marker or row colors)? I know I can highlight all rows manually and right click and "clear color", but how I do this using script? Thanks in advance!

2 REPLIES 2
jthi
Super User

Re: Clear cell colors

JMP is able to script that for you

// Clear color for selected cells
Data Table("Untitled") << Select All Rows;
For Each({col}, {:Column 1, :Column 2}, col << Color Cells(""));

so with slight modification

For Each({colname}, Current Data Table() << Get Column Names("String"),
	Column(Current Data Table(), colname) << Color Cells("");
);
-Jarmo
txnelson
Super User

Re: Clear cell colors

Select the column(s) you want to Clear the Cell Colors from, and then go to

     Cols=>Clear Cell Colors

txnelson_0-1733117901869.png

 

Jim

Recommended Articles