Change Icon Color based on Number Value (Simple!)

[zalandoe]

My app currently tracks the number of days since we last invoiced our client with a DateDiff function

DateDiff(DataCardValue12.SelectedDate,Today())

I have placed circle icons on my app that I want to change color based on how many days it has been since the invoice has been sent (like a color status update).

A green circle for most recent and red being a very long time.

It seems sooooo easy but I cannot figure it out. Here is my if statement in the fill property of a circle:

If('Number of Days' > 1, Green, LightGray)

*Number of Days is name of the text label where the DateDiff function is found

The error I get is that If statement is expecting a number but I've tried 'Number of Days'.Value and that doesn't work either.

Thanks for the help!

[RezaDorrani · Accepted solution]

Hi @zalandoe 

If(Value('Number of Days'.Text) > 1, Green, LightGray)

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[zalandoe]

Thanks so much! I thought I had tried that solution at one point and dismissed it completely!

[TheRobRush]

[zalandoe]

Woah, that is great. Thanks!

[TheRobRush]

haha oops he beat me to it

[echodapogi]

Hi Reza, 

I have same scenario of this problem but i cannot figure it out how to work. Can you also please help?

I have a TextInput box and a rectangle color box, i want to change the color based on the values of the text input. 

here is my code. but i cannot work on the between value of between <=0.5 and <=0.9. 

If(Value(TextInput2.Text) < 0.5, Red,
If(Value(TextInput2.Text) <=0.5 && Value(TextInput2.Text) <= 0.9, Yellow,
If(Value(TextInput2.Text) >=1, Green,
Black

)))

i need to do color coding in the box based on this formula. 

<0.4	Red
<= 0.5 and <1	Yellow
>=1	Green

Thanks in Advance

Echo