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.