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
|