Conditional formatting

[Rooky228]

I would like to have alternating row shading on a large spreadsheet. I would
like the shading to alternate every time there is a change in content in
column C.
Sometimes there's 2 or 3 cells filled with the same content. And sometimes
it changes after only one cell.

 

[Max]

What you're after is covered in David McRitchie's page at:
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Scroll down about one third of the page, look for:
Color Grouping with alternating colors (#grouping)

 

[Rooky228]

You're exactly right. Thanks so much!

What you're after is covered in David McRitchie's page at:
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Scroll down about one third of the page, look for:
Color Grouping with alternating colors (#grouping)

 

[Max]

welcome, thanks for the feedback.