conditionned formatting: max. number of rules

[Sven Berg]

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

 

[Barb Reinhardt]

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

 

[Sven Berg]

Great solution. Many thanks again!
Sven

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
--
HTH,
Barb Reinhardt





- Zitierten Text anzeigen -