User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
RGB Color Matching Script
John_Powell_JMP
Staff John_Powell_JMP
Staff
Created: Oct 16, 2014 02:28 PM  |  Last Modified: Nov 14, 2016 12:52 AM
RGBColorName.jsl
SampleColors.jmp


This script is a suggested solution for Re: RGB Values to Color Names in Data Table.

It uses the values in the Red, Green, and Blue columns to look for a color name in a color table and put the name in the Color Name Column.

The script also sets the cell color for the sample and the color name. Here's an example of the results of running the script:

RGBToColorNames.PNG

The rows near the bottom, are exact color matches followed by close matches.

Note: It looks like if you try to color a cell with pure black, white is used instead.

I'm not the most experienced JSL programmer so I asked melaniedrake for advice. Thanks, Melanie.

I attached a new version of the script inspired by MS in the comments of Re: RGB Values to Color Names in Data Table.

Recommended Articles