Background color of alternating lines in pairs of three

[ruiviagem]

Hello everyone, I need your help.
needed to alternately color the visible lines from three to three,
because when I apply a filter or hide the lines everything is unformatted.
I used the formula this formula (= MOD (ROW () - 5; 6)> = 3)
in conditional formatting ...
(

I'm a bit of a frog in excel ))))
Thanks!

 

[jasonb75]

Try

=MOD(SUBTOTAL(103;$C$5:$C5)-1;6)>2

Note that I've used column C as a reference, the range in the formula must use a column that will have data in every row (no merged rows).
Note also that there are 3 $ symbols in the formula, it they are incorrectly placed then it is likely to fail.

 

[ruiviagem]

Try

=MOD(SUBTOTAL(103;$C$5:$C5)-1;6)>2

Note that I've used column C as a reference, the range in the formula must use a column that will have data in every row (no merged rows).
Note also that there are 3 $ symbols in the formula, it they are incorrectly placed then it is likely to fail.

Works perfectly : )
Thank you very much!!!