How to show text only when a specific selection is made in a list box?

[chiranjivdas]

I have a list box where users can select the company. Some companies have multiple transactions. I want a text box to appear when the selected company has multiple transactions.

For example, ABC Company has only one transaction so I do not want the text to appear when ABC company is selected. But XYZ Company has 2 transactions, and I want the text to appear when XYZ Company is selected warning users that there are multiple transactions involved. Even better if I can make this text box with flashing colors.

Thanks for your help,

Chiranjiv

Company	Transaction ID	Sales
ABC Company	1210	$50,000
XYZ Company	1141	$35,000
XYZ Company	1512	$40,000

[sunny_talwar · Accepted solution]

May be use this as hide/show condition for your text box object

GetSelectedCount(Company) = 1 and Count([Transaction ID]) > 1

Sample attached