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