Highlight rows of data based on value

  • Thread starter Thread starter koturtle
  • Start date Start date
K

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
 
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
 
Back
Top