Hello,

I'm using Excel 2007. I have several values in a certain column, and want to
shade each row appropriately. I'll write it out.

'COL D'

1
2
1
4
3
1
5
4
3
7

....and so on. Basically, each time '1' appears, it should highlight the row
a different color than '5,' which is itself unique, etc. I'm sure this is a
snap with Excel 2003, but the new version doesn't like those solutions, so I
figured I'd ask.

What successful solution from 2003 have you tried unsuccessfully in 2007?
What was the result in 2007?
--
David Biddulph

"BryGuy77" wrote in message
...
Hello,

I'm using Excel 2007. I have several values in a certain column, and want
to
shade each row appropriately. I'll write it out.

'COL D'

1
2
1
4
3
1
5
4
3
7

...and so on. Basically, each time '1' appears, it should highlight the
row
a different color than '5,' which is itself unique, etc. I'm sure this is
a
snap with Excel 2003, but the new version doesn't like those solutions, so
I
figured I'd ask.