Conditional formatting or not?

[Donmazzei]

Hi all I really need your support in this. Il try to explain as best as I can.

So I have a drop list say in e4 and what I want it to do is to change the the previous 3 cells I e b3 c3 and d3 to a certain color when you select a certain item on the list in e4.


How do I do it?
Thank you all!!!

 

[etaf]

do you want b3,c3,d3 different colours for the same item ?

if not
then setup different rules for each colour for each item.
then you could use a LIST or hardcode it in

for 2007, 2010 , 2013 or 2016 excel version
Conditional Formatting

Highlight applicable range >>

B3,C3,D3


Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:


=$E3="item name on the list 1"


FormatÖ [Number, Font, Border, Fill] choose the fill colour
choose the format you would like to apply when the condition is true
OK >> OK

Next
Repeat the above with a different rule for item 2 and colour

Book1
	B	C	D	E
2
3				Oranges
4
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:D3	Expression	=$E3="Oranges"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
E3	List	=$I$1:$I$3

 

[Donmazzei]

Sir you are a legend!!! Lol

 

[etaf]

you are welcome

 

[Donmazzei]

do you want b3,c3,d3 different colours for the same item ?

if not
then setup different rules for each colour for each item.
then you could use a LIST or hardcode it in

for 2007, 2010 , 2013 or 2016 excel version
Conditional Formatting

Highlight applicable range >>

B3,C3,D3


Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:


=$E3="item name on the list 1"


FormatÖ [Number, Font, Border, Fill] choose the fill colour
choose the format you would like to apply when the condition is true
OK >> OK

Next
Repeat the above with a different rule for item 2 and colour

Book1
	B	C	D	E
2
3				Oranges
4
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:D3	Expression	=$E3="Oranges"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
E3	List	=$I$1:$I$3

If i wanted it for a certain selections such as Holi or Toil. I could use an or function i take it?

 

[etaf]

YES , if you want the same colour

=OR( $E3="Holi",$E3="Toil")

Book1
	B	C	D	E
3				Oranges
4				Holi
5				Toil
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B4:D5	Expression	=OR($E4="Holi",$E4="toil")	text	NO
B3:D3	Expression	=$E3="Oranges"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
E3	List	=$I$1:$I$3
E4:E5	List	=$I$1:$I$5