formula required for conditional formatting - Microsoft Community

i need highlight cells based on input particular cell has drop down list. 

a	b	c	d	e	f	g	h	i	j	k	l
1	type	location-a	location- b	location- c	location- d	location- e	location- f	location- g	no. of compulsory location	no. of location fruit arrived	% complete
2	apple	9/4/17		9/4/17	9/4/17		9/4/17		5	4	80
3	mango	9/4/17	9/4/17	9/4/17	9/4/17		9/4/17	9/4/17	6	6	100
4	apricot	9/4/17		9/4/17					5	2	40

column b has drop down list b2 can either apple,mango or apricot selected. if apple selected corresponding delivery location a,b, c, d, f compulsory , needs highlighted using colour brown(i.e c2,d2,e2,f2,h2). if mango selected in b2, location a,b,c,d,h,i (i.e c2,d2,e2,f2,h2,i2)should highlight using colour brown. if apricot selected in b2, location a,b,c,d,e,f (i.e c2,d2,e2,f2,h2)should highlight using colour brown.

the same shall applicable b3 & b4. please suggest how this.

hi

for mango , apricot columns inconsistent locations have provided in description.

>"if mango selected in b2, location a,b,c,d,h,i (i.e c2,d2,e2,f2,h2,i2)" - should locations a,b,c,d,f,g?

>"if apricot selected in b2, location a,b,c,d,e,f (i.e c2,d2,e2,f2,h2)" - should c2:h2?

for description below, have assumed, change suit intended.

select c2:f4

hold down ctrl key , select h2:h4

click conditional formatting->new rule->use formula determine cells format

in space formula, put =$b2="apple"

click format , set fill colour brown.

click ok, ok

select c2:f4

hold down ctrl key , select h2:i4

click conditional formatting->new rule->use formula determine cells format

in space formula, put =$b2="mango"

click format , set fill colour brown.

click ok, ok

select c2:h4

click conditional formatting->new rule->use formula determine cells format

in space formula, put =$b2="apricot"

click format , set fill colour brown.

click ok, ok

Office / Excel / Microsoft Office Programming / Office 2010