Conditional formatting
 

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.

Conditional formatting
 

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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rooky228" wrote:
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.

Conditional formatting
 

You're exactly right. Thanks so much!

"Max" wrote:

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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rooky228" wrote:
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.

Conditional formatting
 

welcome, thanks for the feedback.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rooky228" wrote in message
...
You're exactly right. Thanks so much!