I Need a Tearoff Color Palette
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 |
I Need a Tearoff Color Palette
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 |
I Need a Tearoff Color Palette
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 |
I Need a Tearoff Color Palette
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 |
I Need a Tearoff Color Palette
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 |
I Need a Tearoff Color Palette
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 |
I Need a Tearoff Color Palette
Bernie,
The question then becomes, what do you recommend for me to do? thanks. Jon "Bernie Deitrick" wrote: 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 |
I Need a Tearoff Color Palette
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 "Jonrgrover2" wrote in message ... Bernie, The question then becomes, what do you recommend for me to do? thanks. Jon "Bernie Deitrick" wrote: 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 |
All times are GMT +1. The time now is 03:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com