Shading Alternate Unhidden Rows in Excel

I have a file that contains multiple rows of data. I built a macro that will then hide rows with a $0 balance. When the macro is completed, my spreadsheet is only showing the lines with a $ amount. (The $0 rows are hidden)

What I'd like to do is then format the unhidden rows so that each alternate row is color coded. This will help separate the rows visually so I can more easily follow the rows across to view $'s per line.

I've attached a sample spreadsheet (it does contain the macro to hide the $0 rows). How can I then format the remaining rows with alternate shading?

Thanks so much for your help!Alternate Shading Example.xlsm

Originally Posted by Richard Buttrey

Hi,

Have you tried the 'Format As Table' functionality and then picking one of the pyjama stripe styles?

I hadn't even thought of that. I don't have the formatting down perfectly yet, but it seemed to work just fine based on one of the "canned" table styles.

Originally Posted by daddylonglegs

Assuming B14:B32 will always be fully populated then select the whole range of your table B14:Q32 and use this formula in conditional formatting

=MOD(SUBTOTAL(103,$B$14:$B14),2)

That will format alternate visible rows

Make sure the $ signs are exactly as shown

This worked perfectly. Thanks!