Jon,

If I have ever heard of anybody who needs a macro, you are that person - nobody should do anything
to 1 million cells manually. Can you describe the process by which you choose the color for a cell?

HTH,
Bernie
MS Excel MVP


"Jonrgrover2" wrote in message
...
I my work I have over 1 million cells to individually color. The effort of
moving my mouse back and forth between the workspace and the menus in Excel
2007 makes this prohibitive. Will there be anohter teroff color palette in
the next version?


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions