web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Conditional Formatting...

Power Apps

Answered

Conditional Formatting with <> and colors

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I am doing a project where I what to know if something is over a time limit to color it a certain color, or if it's under a certain time limit it colors the box a different color. Here is what I have so far:

If(

Value(Lastupdate.Text)> 1,

Hours, Color.Chartreuse=Green,

Value(Lastupdate.Text)< 2,

Hours, Color.Red=Red,

Color.Yellow=Yellow

Any ideas on how to fix this?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
In the textbox you want to change the color of, in the Color property, use this:
If(And(Value(Lastupdate.Text)>=1,Value(Lastupdate.Text)<2),Green,If(Value(Lastupdate.Text)<=2,Red,Yellow))
---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @Anonymous,

Could we get some more details on what scope you want the colours to fall in - I am going to assume all values up until 1 are Green, 1 to 2 are orange and anything greater than 2 is red - would that be correct?

I am going to try to make the code more visually-friendly so that you don't have to dissect it several months later when reviewing it:

If( //Condition 1 Value(Lastupdate.Text)>=0 && Value(Lastupdate.Text)< 1, Chartreuse, //Condition 2 Value(Lastupdate.Text)>=1 && Value(Lastupdate.Text)<=2, Yellow, //Else condition (any value larger than 2) Red )

Can we assume that your Lastupdate is a label and that it shows numbers values such as 1.5 ?

Let me know if this helps or if you need any further information with implementing this,

Cheers,

Sancho

Was this reply helpful? Yes No

Join the conversation