Changing row colors when value in cell changes

  • Thread starter Thread starter silky_green
  • Start date Start date
S

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!
 
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
 
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.
 
Thanks "swatsp0p" (Bruce) and David McRitchie for this! This is exactl
what I was looking for! Thank you
 
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
 
Back
Top