Excel - Conditional Formatting is altered

[TKT-Tang]

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.

 

[Dave Hawley]

I don't get this happening on Excel 2002.

FYI You don't need to use the "Format Painter" to copy conditional
formats. Simply select the range, eg A1:A10, where A1 is the Active Cell
in the Selection then use a formula like

=A1="Cat"

Excel will automatically change cell references for you.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[TKT-Tang]

Mr. Dave Hawley,

Thank you for responding to my query.

The query was based on working with XL2000.

However, following your reply and giving another attempt at XL2002,
the coditional formatting is not altered thereof.

Regards.