Color cue when value is greater in text field

[New_Bee77]

Below is the sample field value.  I wanted to show text in Red when I find numeric value in the filed greater or equal to 50%.  I have two filesystem in one field.

"/var 18%, /var/hsc/log 50%" (Red)

"/var 35%, /var/hsc/log 24%"

"/var 77%, /var/hsc/log 65%" (Red)

[brunobertels]

hi may be this 

if(right('"/var 18%, /var/hsc/log 50%"',3)<=0.5,lightred())

[New_Bee77]

I should be able to use field name instead of data

Var (Field name)

"/var 18%, /var/hsc/log 50%"

"/var 35%, /var/hsc/log 24%"

"/var 77%, /var/hsc/log 65%"

[brunobertels · Accepted solution]

Hi 

Yes 

if(right([YourFieldName],3)<=0.5,lightred())