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" wrote:

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?