#1   Report Post  
clive
 
Posts: n/a
Default Excel and PMS colors

I need to print the colored type in excel documents as a PMS in a monthly
catalogue. Is there a way to change this in excel or to convert it through
third party software?
The system now is PC excel to PDF to PC Illustrator - change colors to pms
then resave as PDFs for Mac InDesign. Toooooooo long!
  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

Perhaps there is an easier way, but this should work--provided you have the
RGB values for the colors you need (If you don't, you should be able to
figure out what they are in Illustrator with the color palette).

Open an new Excel workbook. Go to Tools | Options | Color. Customize the
existing color palette to the colors of your choice. Note: There are only 56
colors available in Excel at any one time--if you need more than that, you
will need to continue doing what you are doing. Also, if the colors you need
vary significantly each time, this method won't be any more efficient than
what you are doing.
Save the file as Colors.xls.
When you need to put the colors into a different spreadsheet.
1. Open both the destination workbook and Colors.xls.
2. Make sure the destination workbook is the avtice workbook.
3. Go to Tools | Options | Color and pick Colors.xls from the drop-down list
for Copy colors from.

With all of that done, you can then apply the colors directly to the
destination workbook.
If you have to do this for a lot of colors, this will seem like a lot of
work. Just remember that you only have to set the colors choices once
(provided you are using the same colors each time), then just reuse
Colors.xls.

--
tj


"clive" wrote:

I need to print the colored type in excel documents as a PMS in a monthly
catalogue. Is there a way to change this in excel or to convert it through
third party software?
The system now is PC excel to PDF to PC Illustrator - change colors to pms
then resave as PDFs for Mac InDesign. Toooooooo long!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"