Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
"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 |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
Opening an Excel file | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Colors with EXCEL 2003 | Excel Discussion (Misc queries) | |||
How to get excel cells to change colors depending on value | Excel Worksheet Functions |