PDA

View Full Version : [SOLVED] Banding Formats



snowdyce
05-29-2014, 12:38 PM
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.

11752

Thanks,
Sean

p45cal
05-29-2014, 02:29 PM
is this any good:?
http://www.ablebits.com/office-addins-blog/2014/03/13/alternate-row-column-colors-excel/#value-based

snowdyce
05-30-2014, 05:39 AM
Yes this will work. Thank you!