This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
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: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
RGB Color Matching Script
John_Powell_JMP
Staff John_Powell_JMP
Staff
Created: Oct 16, 2014 02:28 PM  |  Last Modified: Nov 14, 2016 03: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.