Conditional Formatting based on Percentage Value

[Danny_L]

Hey all,

I have a Field that is View Percentage in an Edit Form and I wanted to have the fill color be Red if it is less than or equal to 50%, Yellow if it is between 51% and 75% and Green if it is greater than or equal to 76%. 

In trying to test just the first part, the value in the field currently is 80% and I have this in the fill property:

(If(ThisItem.CurrentYieldPercentage<= Value("50%"), Red,Blue))

It changes the fill color to Red which wouldn't satisfy the formula. 

This is what is in the text portion of the field:

Round(((Parent.Default - Parent.Min) / (Parent.Max - Parent.Min)) * 100, 2) & "%" (This was there when the field was added)

Anyone have any clue how to accomplish this? 

Thanks!

[RandyHayes · Accepted solution]

@Danny_L 

Change your Fill property to the following:

If(Value(Self.Text) > .75, Green,
   Value(Self.Text) > .5, Yellow,   
   Red
)

That should give you what you want.

I hope this is helpful for you.

[gabibalaban]

Hi @Danny_L ,

If your CurrentYieldPercentage is a number column, I think that's wise to correct your formula as:

If(ThisItem.CurrentYieldPercentage <= 0.5, Red,
    ThisItem.CurrentYieldPercentage > 0.5 && ThisItem.CurrentYieldPercentage <= 0.75,Yellow,
    Red
)

The text property value doesn't affect the color property (or maybe I don't get correctly the hole imagine).

Hope it helps !

[Danny_L]

Thanks @RandyHayes . I think I need to put you on retainer, haha. Again appreciate it

[leslie_rivera]

@RandyHayes  How about based on percentage value between two numbers?

Basically, I have an app where chemists are entering numbers. I already have calculations in the background that provide a final percentage.

What I need is those percentage fields need to be color formatted:  
Green for OK(the numbers are within .2 of each other) and Red for something is wrong (are not within .2)

Using the graph below. Ash 1 calculation is 13.39% and Ash 2 calculation is 13.4% .

If Ash 1 and Ash 2 are within .2 of each other the box should stay green -> if not it should turn red.

I tried using this formula in the fill value of both fields:  If(Value(Ash1.Text)-(Ash2.Text)<=.2,Green,Red)

However, it sometimes works. Any ideas on how I can write this one?