Dynamic Color Banding on similar rows with Filtering

[Matthew Recknagel]

Hello Mr. Excel,

I have been searching on multiple occasions for a solution to my highlighting needs. At one point and time I found a guide that showed me how to highlight all rows that had the same cell value, then when the cell value changed it would alternate the shading. It used a MOD formula that was inserted into the first column and returned a 0 or 1 as pictured below, then with conditional formatting you could highlight based off of the 1 or 0. This worked great until I wanted to filter the data, lets say odds only, it would filter but keep the original Mod formula value resulting in the table to not be alternate shading any more. (could not highlight so i used bolded text to show what i mean)

Unfiltered Table				Filtered Table (odds)
Mod Formula	Sorted Value	Data		Mod Formula	Sorted Value	Data
0	1	10		0	1	10
0	1	10		0	1	10
1	2	35		0	3	6
0	3	6		0	3	7
0	3	7
1	4	5
1	4	5
1	4	10

<tbody>
</tbody>

My question would be, is there any conditional formatting setup that could alternatively shade based on cell value AND work with filtering? I have seen many guides that alternate shading every 2 or 3 rows which is not what i am looking for. Any help?

Thank You,
Matt Recknagel