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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 12, 2017 at 11:38 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 12, 2017 at 11:38 AM
Related:
- Show text in one cell upon drop down list selection in another
- My contacts list names - Guide
- Whatsapp country code list - Guide
- How to change your best friends list on snapchat to 3 - Guide
- Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 12, 2017 at 11:32 AM
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
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
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jun 12, 2017 at 11:38 AM
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
Use the following formula in F2 for that:
=IF(D2="custom","Not Included","Included")
Best regards,
Trowa