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