View Single Post
  #1   Report Post  
Andrew
 
Posts: n/a
Default 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