I understand that there is a VB work around for the three-condition limit on
conditional formatting but, frankly, that is not the same as an unlimited (or
reasonably large) number of conditions. I shouldn't have to resort to writing
VB code to do what the program clearly can do already any more than I should
have to reprogram my automobile engine's ignition-control computer just
because I want to drive up a steep hill. The three-condition limit is simply
too restrictive. Given the computational and memory resources available to
the application, is there any rationale for such a limit? I can think of
dozens of cases where I would use the feature to enhance the readibility of
information-tracking and -reporting spreadsheets but most of these would
depend on an ability to set a dozen or more conditions.

----------------
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

Then you'll like xl2007.

Joshua, Technical Editor wrote:

I understand that there is a VB work around for the three-condition limit on
conditional formatting but, frankly, that is not the same as an unlimited (or
reasonably large) number of conditions. I shouldn't have to resort to writing
VB code to do what the program clearly can do already any more than I should
have to reprogram my automobile engine's ignition-control computer just
because I want to drive up a steep hill. The three-condition limit is simply
too restrictive. Given the computational and memory resources available to
the application, is there any rationale for such a limit? I can think of
dozens of cases where I would use the feature to enhance the readibility of
information-tracking and -reporting spreadsheets but most of these would
depend on an ability to set a dozen or more conditions.

----------------
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

--

Dave Peterson