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