How do I get Pantone colors in Excel?
 

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" skrev i melding
...
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,

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

"Harald Staff" wrote:

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" skrev i melding
...
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" wrote in message
...
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

"Harald Staff" wrote:

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


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

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

"Odd" skrev i melding
...
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

"Harald Staff" wrote:

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" skrev i melding
...
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.