Conditional Formatting Issue While Grouping

[STCrosstown]

I am using the following formula to apply a fill color to every other line on a worksheet.

=MOD(ROW(),2)=0

I am also trying to group rows to condense the sheet for a summary presentation. Problem is, when I group the rows the formatting does not adjust so I get numerous rows of shaded or non shaded ones next to each other.

 

[STCrosstown]

Sorry, the formula is used to apply conditional formatting

 

[dreid1011]

How are you grouping the rows? That cf formula should not be affected.

 

[STCrosstown]

Just using the group button on the data ribbon

 

[dreid1011]

Well, I can't say I am familiar with the grouping tool, but I tried it and I don't think I got the results you're describing. It has the option of collapsing the grouped rows... maybe that is skewing the cf highlighting?

 

[Peter_SSs]

Welcome to the MrExcel board!

See if this work-around is of use to you. It requires Excel 2010 or later.
For my sample, the first row of the first group is row 4. You will have to adjust the instructions below if starting at a different row.

In a vacant column (I have used column J) Fill from row 4 (or row 1 it wouldn't matter) down at least as far as the bottom of your last group (doesn't matter if it goes further) with the number 1
You can later hide that helper column if this method works for you.
Select the range to be banded (for me A4:C26)
Apply this Conditional Formatting formula rule: =MOD(AGGREGATE(2,1,$J$4:$J4),2)=0
Test