Highlight rows of data based on value

[koturtle]

Is there a way to highlight groups of data automatically by value.

Part Number
ABC
ABC
ABC
BBB
BBB
CAD
CAD
BAD

I would like to highlight all the ABC one color and the BBB another
and so on automatically.

tia,
ko

 

[Gord Dibben]

Not too easily using multiple colors but could be done using Conditional
Formatting.

Depends upon how many "and so on's" there are and how hard you want to work on
this.

Easy enough to use Conditional Formatting to color-band alternate groups using
two colors only.

See Chip Pearson's site for how-to.

http://www.cpearson.com/excel/ContentBanding.aspx


Gord Dibben MS Excel MVP

 

[CWatters]

Is there a way to highlight groups of data automatically by value.

Part Number
ABC
ABC
ABC
BBB
BBB
CAD
CAD
BAD

I would like to highlight all the ABC one color and the BBB another
and so on automatically.

tia,
ko

Perhaps see..

http://en.kioskea.net/forum/affich-21716-conditional-formatting-more-than-3-in-excel