Alternating Row Formats When Cell Value Changes

[Guest]

I have a list of schools with the school names in column B and the school's
district number in column C. I'd like to alternate the row shading each time
the district number changes. Is there a formula that can be used for
conditional formatting, VB code or some other method to do this?

Thanks for any help or advice,
Andrew

 

[Jim Cone]

My Excel add-in "Shade Data Rows" does that.
It shades 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)


"Andrew"
I have a list of schools with the school names in column B and the school's
district number in column C. I'd like to alternate the row shading each time
the district number changes. Is there a formula that can be used for
conditional formatting, VB code or some other method to do this?
Thanks for any help or advice,
Andrew

 

[Guest]

Thanks Jim. I also found a formula that uses the MOD function that also works
at
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Andrew

 

[Jim Cone]

Andrew,

Well that's good, because my response to your email was returned...

"The following message to <censored> was undeliverable.
The reason for the problem:
5.1.0 - Unknown address error 550-'5.7.1 <censored>... Relaying denied'

Jim Cone
San Francisco, USA

"Andrew" <[email protected]>
wrote in message
Thanks Jim. I also found a formula that uses the MOD function that also works at
http://www.mvps.org/dmcritchie/excel/condfmt.htm
Andrew