• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 161
  • Last Modified:

Traffic lights not working

Attached is a some traffic light formatting with custom formatting

You can see that the mimus 8% is viewing as amber but should be green

Basically i want to display green if the % decreases, red if % increases and amber if it stays the same

Thanks
IA-MI-EE.xlsx
0
Seamus2626
Asked:
Seamus2626
  • 3
  • 2
1 Solution
 
Rory ArchibaldCommented:
The actual value, or the displayed value? ;)
0
 
Rory ArchibaldCommented:
If the displayed number, then the rules should be:
Green: >0 Number (NOT percent)
Amber: <=0 and >=0 Number
Red: <0 Number
0
 
Seamus2626Author Commented:
Actual numbers.....i just dont know how to apply the rules to these traffic lights, ive never used them before
0
 
Rory ArchibaldCommented:
In that case, same as above but reverse the icons.
0
 
Seamus2626Author Commented:
Perfect :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now