Visual Progress tolerance icon sets

[nparsons75]

Hi,

I think this is a tricky one, it certainly is for me....

I need to display visually how well a project is running based on some date and percentage values.

[TABLE="class: grid, width: 1000"]
<tbody>[TR]
[TD]START DATE[/TD]
[TD]TODAY DATE[/TD]
[TD]DUE DATE[/TD]
[TD]PROJECT AGE[/TD]
[TD]PROJECT LENGTH[/TD]
[TD]% EXPECTED[/TD]
[TD]Actual Progress[/TD]
[TD]Visual[/TD]
[/TR]
[TR]
[TD]1/1/17[/TD]
[TD]22/08/17[/TD]
[TD]31/12/17[/TD]
[TD]233[/TD]
[TD]364[/TD]
[TD]64%[/TD]
[TD]50%[/TD]
[TD]AMBER[/TD]
[/TR]
</tbody>[/TABLE]


So, in my table the % expected value is suggesting that the project should be 64% complete at the current date (today, 22/08/17).

We are actually only at 50% completion therefore the visual shows an AMBER COLORED cell. To achieve this I would like to have tolerances or ranges. Example below.

If the Actual Progress is = or greater than 64% then the visual will be GREEN.

If the Actual Progress is < or within 10% of the % expected then the visual will be AMBER. (53% to 63% in this case)

If the Actual Progress is > 10% below the % expected then the visual will be RED.

I have tried using Icon sets but couldn't get them to work as needed.

Thanks in advance if anyone can solve this...