M
Mr. Low
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
--
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/com...f-bfdb1a82da3f&dg=microsoft.public.excel.misc
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 said:
--
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/com...f-bfdb1a82da3f&dg=microsoft.public.excel.misc