Change symbol color based on specific criteria.
I want to change symbol color based on the below criteria.
Red- if Status = "Scheduled" and Days open is equal to or greater than 14
Yellow- if Status = "Scheduled" and Days open is between 9 & 14
Green- if Status = "Scheduled" and Days open is less than 10
Gray-If Status = "Complete"
I may not need the "status = Scheduled" part really.
Best Answer
-
Give this a shot...
=IF(Status@row = "Complete", "Gray", IF([Days Open]@row >= 14, "Red", IF([Days Open]@row >= 9, "Yellow", "Green")))
Answers
-
Give this a shot...
=IF(Status@row = "Complete", "Gray", IF([Days Open]@row >= 14, "Red", IF([Days Open]@row >= 9, "Yellow", "Green")))
-
Paul,
You are quickly becoming my new best friend. Thanks, it worked perfectly.
-
-
Hi,
I was trying to do something similar, and it worked. Thank you Paul. 🖖
Help Article Resources
Categories
Check out the Formula Handbook template!