Row Color

[briank]

My spreadsheet has about 10K records all sorted in column A by a number that
may be unique or repeated several times. I would like to color code the rows
(alternating yellow & white) based upon this singular or grouping of numbers
in column A so that it becomes easier for the view to browse. There are way
to many numerical numbers in column A do attempt any conditional formatting.
Any idea of a macro or code that allows for this type of color coding on such
a wide variety of numbers?
Example
ColA ColB ColC Color
2334 CA April yellow
2334 OH June yellow
2367 WA May white

 

[Jim Cone]

My Excel add-in "Shade Data Rows" does that.
It will shade groups of like valued rows or will shade by every nth row.
Choice of shade colors and an option to skip hidden rows.
Comes with a one page Word.doc install/use file.
It is free upon direct request. Remove XXX from my email address.
Jim Cone
San Francisco, USA
(e-mail address removed)


"briank"
<[email protected]>
wrote in message
My spreadsheet has about 10K records all sorted in column A by a number that
may be unique or repeated several times. I would like to color code the rows
(alternating yellow & white) based upon this singular or grouping of numbers
in column A so that it becomes easier for the view to browse. There are way
to many numerical numbers in column A do attempt any conditional formatting.
Any idea of a macro or code that allows for this type of color coding on such
a wide variety of numbers?
Example
ColA ColB ColC Color
2334 CA April yellow
2334 OH June yellow
2367 WA May white