How do I get Pantone colors in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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

Odd said:
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
Click to expand...
options.
 
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
 
Odd said:
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
Click to expand...

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
 
Back
Top