Banding Formats

[snowdyce]

Hello experts,

I am trying to see if its possible to apply formatting to Rows based on a change of value in the Columns. I want to add some Banding, like every other group is gray or white.

So in column A I have a list of Entities, and the number of Rows varies based on a selection. Hover each change in value happens Every 7 rows. Below is an example of what I am trying to accomplish. I think i can do some sort of formatting a range of every 6 rows? then End at last row? Any ideas are appreciated.

2014-05-29_15-35-45.jpg

Thanks,
Sean

[p45cal]

is this any good:?
http://www.ablebits.com/office-addin...l/#value-based

[snowdyce]

Yes this will work. Thank you!