Label Text with Formula

[lolla70]

Hello

I created a Label and 
Set(varResult, "Well-check Status Required");

Then on the Label I have If Statement

Text : 

If(ListBox3.Selected.Value = "Yes", "No Work",
ListBox3.Selected.Value = "No", "Work")

Fill:

If(ListBox3.Selected.Value = "Yes", Yellow,
ListBox4.Selected.Value = "No", LightGreen)

My question is how I add my varResult to the Text and Fill? When I do this, it is giving me error.

Text : 

varResult,

If(ListBox3.Selected.Value = "Yes", "No Work",
ListBox3.Selected.Value = "No", "Work")

I want the lblResult to start with "Well-check Status Required" and If they select ListBox3 the text change to "No Work"

[eka24]

Try this:

varResult&" "&

If(ListBox3.Selected.Value = "Yes", "No Work",

ListBox3.Selected.Value = "No", "Work")

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[lolla70]

Thank you so much, I tried it and it works the first time then it is giving me a black color. I added on Fill and it didn't work

If(
varResult = "Well-check Status Required",
Yellow
)

If(ListBox3.Selected.Value = "Yes", Yellow,
ListBox4.Selected.Value = "No", LightGreen)

[eka24]

Please did you say it did not work for both the Text and the Color or it worked for Text Only?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[eka24]

Text

varResult&" "&If(ListBox3.Selected.Value = "Yes", "No Work",

ListBox3.Selected.Value = "No", "Work")

Fill

If(ListBox3.Selected.Value = "Yes", Yellow,

ListBox3.Selected.Value = "No", LightGreen)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[lolla70]

I want if there is no selected value the Sentence "Well-check Status Required") Yellow color and if selected to Yes or No, the value then will change based on the Yes, or No and the Yellow or Lightgreen color

When I put the text Formula with no selected value the lblResult is Black.

Thanks for your help much appreciated!

[eka24 · Accepted solution]

Change the formula to:

Text:

If(IsBlank(ListBox3.Selected.Value),"Well-check Status Required",

"Well-check Status Required"&" "&If(ListBox3.Selected.Value = "Yes", "No Work",

ListBox3.Selected.Value = "No", "Work"))

Fill

If(IsBlank(ListBox3.Selected.Value) Or ListBox3.Selected.Value = "Yes", Yellow,

ListBox3.Selected.Value = "No", LightGreen)

OR

If(IsBlank(ListBox3.Selected.Value),Yellow,

If(ListBox3.Selected.Value = "Yes", Yellow,

ListBox3.Selected.Value = "No", LightGreen))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[lolla70]

Thank you so much, Just tried it and it worked great.