I have three different groups of names that I have to reference (visionally),
I think the easiest way will be by background color. I tried conditional
formating
=OR($a$9="Cumene", "CTLO", "Slack Wax") and then set a background color this
would be group 1(these are different products, each on a different row spread
thru out my sheet, we have 3 different dept. with several different products
in each dept.), I need three different groups. My trouble is getting the
condition to look for the different names in the groups. I can get the
condition to work on 1 name but can not get it to work on several different
names.