With each cell I need to make one or more decisions about the content that
goes in the cell and the position of that content compared to the cells
locally around it. I keep track of the status of the work I have done on that
cell using color. This way I don't have to keep a secondary file or worksheet
of status information.

"Bernie Deitrick" wrote:

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