Alternating Row Formats When Cell Value Changes
 

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

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
XX


"Andrew"
wrote in message
...
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

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" wrote:

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
XX


"Andrew"
wrote in message
...
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

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"
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