Changing row colors when value in cell changes

[silky_green]

Is there a way to change the color of rows when the value in a cell in
that row changes? For example:

A B C
1 tom jones 435 <- this row would be yellow
2 sam doe 435 <- yellow
3 dan smith 657 <- green
4 ed ham 544 <- blue
5 dom less 544 <- blue
6 joe more 888 <- red

etc.

There must be some conditional formatting thing I can do...

Please help.

Thanks!

 

[swatsp0p]

Conditional formatting will work ONLY if you have 3 or fewer color
desired. More than that will require VBA coding. You don't suppl
sufficient information to write a sample formula. What is the criteri
for determining the color of the row?

More details, please

 

[silky_green]

Sorry. What I want to be able to do is for all the rows that have the
same value in column C to be the same color. Does that make sense? It
doesn't have to all be different colors I guess. Just different from
the one below and above so you can easily distinguish the grouping of
rows that have the same value in column C.

 

[swatsp0p]

What you ask CAN be done via Cond. Formatting. However, you will need
to insert a column with a formula to check for changes in the rows.
Detailed instructions can be found here:

http://www.mvps.org/dmcritchie/excel/condfmt.htm#grouping

Thanks to David McRitchie for his hard work developing this procedure.

Good Luck

 

[silky_green]

Thanks "swatsp0p" (Bruce) and David McRitchie for this! This is exactl
what I was looking for! Thank you

 

[swatsp0p]

David did all the work, I just pointed you in that direction. Glad w
could be of help. Thanks for the feedback, it is always appreciated.

Cheers