Excel - Conditional Formatting is altered

Giganews Newsgroups
Subject: Excel - Conditional Formatting is altered
Posted by:  TKT-Tang (tkt_ta…@hotmail.com)
Date: 10 May 2004

1. An Excel tabulation begins at Row 6 ; and then, Cell G6 is subject
to Conditional Formatting as follows :-

=AND(ROWS($G$6:G6)<=COUNTIF($B$6:$B$35,$B$6)+COUNTBLANK($G$6:G6),G6<>"")

2. Subsequently, the Conditional Formatting of Cell G6 is
"Paint-Brushed" to the succeeding cells.

3. And there, a blank row is inserted over Row 6 ; Look at the
Conditional Formatting again, it has changed as follows :-

=AND(ROWS($A$1:$G$7)<=COUNTIF($B$7:$B$36,$B$7)+COUNTBLANK($A$1:$G$7),G6<>"")

4. Now, is that change justifiably outrageous ? Expected, or what ?

5. Regards.

Replies