Conditional Formating Background Color
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. |
Conditional Formating Background Color
=OR($a$9="Cumene", $A$9="CTLO", $A$9="Slack Wax")
-- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "tankerman" wrote in message ... 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. |
Conditional Formating Background Color
Works great Thank YOU
"Bob Phillips" wrote: =OR($a$9="Cumene", $A$9="CTLO", $A$9="Slack Wax") -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "tankerman" wrote in message ... 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. |
All times are GMT +1. The time now is 08:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com