Show text in one cell upon drop down list selection in another

Closed
tarre - Updated on Jun 12, 2017 at 11:35 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Jun 12, 2017 at 11:38 AM
Hello,
I am trying to get text to change in one column based on text selected from list in another;
example in D2 I have a drop down list representing the colour choices for a product that states
red
yellow
blue
custom
If the client chooses red, yellow or blue then it is include in the cost already and under the cost column in F2 should say Included, If the client chooses custom then I would like the cell in F to read Not Included? any tips or tricks?


2 replies

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Jun 12, 2017 at 11:32 AM
tarre, Good morning.

For this your need Conditional formatting does not work.
Conditional formatting works only with aesthetic aspects as color, text format, background color and etc.

You need to apply the IF function to resolve your issue.

Try to use:

F2 -->
=IF(OR(D2="red", D2="yellow", D2="blue"), "Included", IF(D2="custom", "Not included", ""))

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Jun 12, 2017 at 11:38 AM
Hi Tarre,

Use the following formula in F2 for that:
=IF(D2="custom","Not Included","Included")

Best regards,
Trowa
0