How do I get Pantone colors in Excel?

[Odd]

Does anyone know how to get Pantone colors in Excel? The color choices are
limited and there is no way to specify RGB or CMYK in the standard options.

 

[Harald Staff]

Hi

You can modify a workbook's colors in the Tools > Options menu and there is
indeed a way to set the RGB values there. It can also easily be done with
macro code. But you are still limited to the count of 56 colors, so the
question is, what do you need this for in Excel ?

HTH. Best wishes Harald

Does anyone know how to get Pantone colors in Excel? The color choices are
limited and there is no way to specify RGB or CMYK in the standard

options.

 

[Odd]

Harald,

Thanks very much or, tusen takk in case you're Norwegian.

Need to get some spreadsheets to conform to corporate Pantone scheme and use
a conversion table from Pantone to RGB. Presto - colors more or less conform
to corporate identity. Just did as you suggested and it seems like it's
working very well.

Best,
Odd

 

[Fredrik Wahlgren]

Harald,

Thanks very much or, tusen takk in case you're Norwegian.

Need to get some spreadsheets to conform to corporate Pantone scheme and use
a conversion table from Pantone to RGB. Presto - colors more or less conform
to corporate identity. Just did as you suggested and it seems like it's
working very well.

Best,
Odd

There is an RGB function in Excel.According to the site below, you are
limited to a total of 56 colors per workbook but I don't know if there's
alimit on the number of colors you can choose from. You should be able to
assign a color like this:
ThisWorkbook.Colors(1) = RGB(127,35,126)

http://www.cpearson.com/excel/colors.htm

/Fredrik

 

[Harald Staff]

Bare hyggelig det, vet du.

Corporate design can usually be done with less that 20 colors, so you can
probably do this in Excel. Note that the color scheme follows the file, not
the application.

I found a Pantone - RGB table at
http://www.seoconsultants.com/css/colors/conversion/

Best wishes Harald