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
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.
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.
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)
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.