Excel 2007 : Fill color compatibility excel 2007 to excel 2003

Andy - Thank you very much!!! That's too cool!

I added a link/shortcut button to the 2003 color drop down you created to my quick access toolbar for quicker access, renamed sheet 1 to "2003 Color List" and then hid that worksheet. Now if I would rename this file say Book1Colors2003 is there any way I can set the Excel options to have this open as the default workbook?

Also two things I noticed when experimenting with the 2003 Color drop down.
1. The "No Fill" button does not clear the fill from the selected cell.
2. The "Undo" function is not active and will not clear the fill when a cell is filled by the 2003 Color drop down.

I am by no means complaining or criticizing your work. I'd just thought you'd like to know.


I have attached your file with the changes I made in case my explaination wasn't clear.

Again Thank you very much for your help.
Jim