Representing a range of percentages with a number

[flyngcoln]

Hi,
I'm trying to create an interactive databook. I'm needing to represent the percentage ranges below with the grid number associated with them - and then to have the combination of the two numbers that represent a point on the grid with a corresponding colour.
The objective of the databook is to be able to input results into the matrix/grid and be able to determine what results you might need in the future to move to a more desirable cell in the matrix/grid.
Several grid results then add up to an overall result, and I have a formula I need to sit behind the cells that will automatically calculate whatever grid numbers they put in.
Any help is greatly appreciated.

[TABLE="class: grid, width: 384"]
<tbody>[TR]
[TD]Level[/TD]
[TD]1 (Decreased Significantly)
<= -7%[/TD]
[TD]2 (Decreased)
>-7% and <= -2%[/TD]
[TD]3 (Maintained)
> -2% and < 2%[/TD]
[TD]4 (Increased)
>= 2% and < 7% [/TD]
[TD]5 (Increased Significantly)
>= 7%[/TD]
[/TR]
[TR]
[TD]5 (Very high)
>= 50%[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4 (High)
>=40% and < 50%[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3 (Medium)
>=30% and < 40%[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2 (Low)
>= 20% and < 30%[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1 (Very Low)
< 20%[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col span="6"></colgroup>[/TABLE]