Conditional Formatting of alternating rows that adjusts after hiding rows.

I have read many posts in many places with various Formulas for FILTERED row formatting. This is not filtered. There are many places on a report that we may hide rows if that data is irrelevant for this report/presentation kit. I read that it is potentially possible in VBA but it sounds like heavy code if it needs to be done across multiple sheets in select areas that may be dynamic (someone may add a row messing up a static code). I read it may not be possible but I've read that it also may be possible with a helper Column. Has anyone had any luck with having grey/no fill alternating rows in a specific range that updates fill as rows are hidden?

Assuming col A will always have a value and you have a header in row 1 with data starting in row2. You could put
=SUBTOTAL(103,A$2:A2)
into an empty column & fill down.
Then use
=MOD($X2,2)=0
in CF, changing X to the column with the subtotal.

Wow, that works quite well. Thanks! Is there an easy way to have it start with the formatted color?

Yup, just use
=MOD($X2,2)=1