3,295
Hi there,
quick question here:
I have a label and the value of that label could be between 0-50
I would like to insert a circle and change the fill property of that circle as:
if label is equal to "0" and iqual or less than "35" Color Green
if label is equal to "36" and iqual or less than "45" Color Yellow
if label is equal to "46" and iqual or less than "50" Color Red
Any help or a better approach?
thank you kindly
Sure thing...set the Fill property of the circle to the following formula:
Share
Report
All responses (
Answers (
With({lblVal: Value(yourLabel.Text)},
If(lblVal <= 35, Green,
lblVal <= 45, Yellow,
lblVal <= 50, Red
)
)
That should give you what you need.
I hope this is helpful for you.
