conditionned formatting: max. number of rules

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sven Berg - 06 Apr 2008 14:32 GMT

In Excel 2003, the max. number of rules for conditionned formatting of
the same array seems to be limited to 3. Or is there a way to extend
it? In contrast, in Excel 2007, I could create 9 rules so far. What
will be the maximum number here? Thanks, Sven

Reply to this Message

Barb Reinhardt - 06 Apr 2008 17:49 GMT

In Excel 2003, you can expand the number of conditions using a
Worksheet_Change event. I don't know the max number of conditions for 2007,
but I'd bet if/when you hit the max there, you could do the same thing.

http://www.ozgrid.com/forum/showthread.php?t=56616

Signature

HTH,
Barb Reinhardt

> In Excel 2003, the max. number of rules for conditionned formatting of
> the same array seems to be limited to 3. Or is there a way to extend
> it? In contrast, in Excel 2007, I could create 9 rules so far. What
> will be the maximum number here? Thanks, Sven

Reply to this Message

Sven Berg - 06 Apr 2008 22:37 GMT

Great solution. Many thanks again!
Sven

On 6 Apr., 18:49, Barb Reinhardt
<BarbReinha...@discussions.microsoft.com> wrote:

> In Excel 2003, you can expand the number of conditions using a
> Worksheet_Change event. I don't know the max number of conditions for 2007,
[quoted text clipped - 11 lines]
>
> - Zitierten Text anzeigen -

Reply to this Message