bringing in colours from another spreadsheet

[swifts]

I've just been upgraded to Office 2007. In Office 2003 I used to be able to
bring in the colour palette from another open spreadsheet by going to the
tools menu, choosing 'options' and then the colour tab. Does anyone know how
I can do this in Office 2007?

 

[trip_to_tokyo]

Hi swifts.

The way that I do this is just to do a CTRL-C of the colour from my, "old"
(2003) spreadsheet and paste it into my .xlsx spreadsheet.

I don't think this is quite what you want but it works for me.

If my comments have helped you please hit Yes.

Thanks.

 

[swifts]

thanks, but no, it's not quite what I was after, I actualy want to update the
colour scheme. The good thing about briging in the pallette in the old
version of excell was that all existing colours in the spreadsheet were
updated with the new colour scheme.