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.

START DATE	TODAY DATE	DUE DATE	PROJECT AGE	PROJECT LENGTH	% EXPECTED	Actual Progress	Visual
1/1/17	22/08/17	31/12/17	233	364	64%	50%	AMBER

<tbody>
</tbody>

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...