CF 2007 - Highlight entire row based on one cell

B

BryGuy77

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.
 
D

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top