Jon,

Clearly, that is something that cannot be automated. Sorry that I can't be of more help.

Bernie
MS Excel MVP


"Jonrgrover2" wrote in message
...
The colors denote a number of things.
1. The relative position I intend to put that cell into eventually in
relationship to cells nearby in the row.
2. The 'finishedness' of my placement of the cell. So I keep status on how
satisfied I am with the placement of each cell with color.
3. Status on whether the cell has content in it at all yet, has boilerplate
content in it or whether I have updateted the cell content manually.
4. Status on whether I am challenging my earlier content in that cell and
think there is a problem I need to address.
5. The accuracy I think the content within a cell has or the accuracy of of
its position.
Thanks.


"Bernie Deitrick" wrote:

Is specific content a specific color? For example, every time you enter
"Call home" do you color that yellow? Or, if you enter "Call home" next to
a date, do you color it pink if the date is within a week, or blue if the
date is within 2 weeks? If you do follow rules that you can lay out like
that, then you could use the change event to do the coloring for you.

Bernie



"Jonrgrover2" wrote in message
...
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