Change label color based on column value

[Jean_9681]

Hi All,

I would like to change a label color based on a column value, could anyone guide with this please

Column 1 - Budget
Column 2 - Expense

As an example - the number 100 is just an example

If Budget is 100 and Expense is less then 100 i want the label color Green
If Budget is 100 and Expense is slightly over 100 for ex-120 i want the label color Yellow
If Budget is 100 and Expense is 130 and above i want the label color Red

In case if  the above request is not achievable then please suggest how to change the color of the Expense value to Red is its greater than the Budget value.

Thanks for your time. 

[Drrickryp]

@Jean_9681 

With({bg:Budget=100},

Switch(bg & Expense,<100,Green,>=130,Red,Yellow))

[WarrenBelz · Accepted solution]

Hi @Jean_9681 ,

This should show you the colours

With(
   {wVar: Expense - Budget},
   If(
      wVar <=0, 
      Green,
      wVar < 30,
      Yellow,
      Red
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Jean_9681]

@WarrenBelz Thank you, it worked exactly the way i wanted it to.