Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007: Conditional formating of multiband colors
My posting on 7.5.209 entitled Excel 2002: Conditional formating of multiband
colors refers. At present the coditional formating in Excel 2002 and 2007 still do not have this rule for fast job. The user need to run VBA Code or Marcro or using a formula helper column to get the result. Running a a Macro in a network of PC is very risky as the user need to determine reliability of the code with high degree of vigilant. Failure to do so might cause major system problem when a virus program is wrongly run. In view of that I would like to suggest MS to add new rules to the existing conditional formating in Excel 2007 to do this job. In order for MS to make new Excel versions more , powerful ,user friendly and safe to use, more new rules need to be added in Pivot Table, Sub Total Table and conditional formating and other data tools . Jobs previously done by Macro should be converted to new rules in the existing data tool for fast and safe jobs. New data tools also need to be develop to create new possibility of doing a job. Hope my input is helpful to develop the next generation of Excel Spreadsheet. Thanks Low ---------------------------------------------------------------------------------------------- Hi Low, Conditional formatting is based on the outcome of the condition evaluating to True. If the evaluation is True, then the specific color you selected is applied. i believe if you want this color scheme then you will need to use VBA to effect the rotating colors Mr. Low wrote: Hi, I need to conditional format a table with 3 rotating colors of yellow, green and blue. The condition to change the color is when the code changes. Illustration: A B C D 1 B12 XXX XXX Yellow 2 B12 3 C26 Green 4 C26 5 C26 6 D52 Blue 7 E27 Yellow 8 E27 9 E27 10 E27 11 G49 Green 12 G49 13 H96 Blue There is a maximum of 3 formulas under conditional formating. May I know what are the formulas 1, 2 and 3 in order for me to get the result ? Thanks Low -- A36B58K641 ---------------- 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...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Conditional format multiband colors | Excel Discussion (Misc queries) | |||
Conditional Formating/Excel 2007 to 2003 | Excel Discussion (Misc queries) | |||
Excel 2007 conditional formating using 3 traffic lights on percent | Excel Discussion (Misc queries) | |||
2007 Excel conditional formating, reference cell containing specif | Excel Discussion (Misc queries) | |||
Conditional Formating in Excel 2007 | Excel Worksheet Functions |