Format text based on which of several unique lists the value belongs to?

T

tsw632

Hello,

I have several (5 or so) lists of product lines, each of which makes up
a product family (from 5 to 10 product lines per product family). I
would like to assign a font color or cell shading to text cells in a
table of product lines, based upon which product family the product
line belongs to. Anyone know a way to automate this? Thanks.

Troy
 
B

BobT

Use the Conditional Formatting features of Excel. The online help has
excellent walk throughs.
 
Top