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

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

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

" wrote:

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

Thanks Bob. I guess I'm looking for the formula to create my crieria.

BobT wrote:
Use the Conditional Formatting features of Excel. The online help
has
excellent walk throughs.

" wrote:

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