I Need a Tearoff Color Palette

[Jonrgrover2]

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/com...dg=microsoft.public.excel.worksheet.functions

 

[Bernie Deitrick]

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]

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]

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]

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]

Jon,

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

Bernie
MS Excel MVP

 

[Jonrgrover2]

Bernie,

The question then becomes, what do you recommend for me to do?
thanks.

Jon

 

[Bernie Deitrick]

Jon,

For mission critical issues that 2007 doesn't properly address, I would revert to XL2003. Both
versions can reside on the same computer - I think (IIRC) that 2003 needs to be installed before
2007, and double clicking a file will default to 2007, but you can run 2003, open, and edit the
files for which you need the tearoff color palette.

HTH,
Bernie
MS Excel MVP