If you want figures that are lower than a set value to go a certain colour, then why not try Conditional Formatting. Conditional Formatting allows you to add colour to a spreadsheet based on a condition. 

Just go to the Home tab > Conditional Formatting > Highlight Cell Rules > Less Than.

Then type in the figure that is going to be your benchmark, e.g. if you want all numbers less than 3 to be formatted, then type 3. 

Finally select a colour that you want the cell(s) to change to.

If you want figures that are higher than a set value to go a certain colour, then why not try Conditional Formatting. Conditional Formatting allows you to add colour to a spreadsheet based on a condition. 

Just go to the Home tab > Conditional Formatting > Highlight Cell Rules > Greater Than.

Then type in the figure that is going to be your benchmark, e.g. if you want all numbers greater than 3 to be formatted, then type 3. 

Finally select a colour that you want the cell(s) to change to.

If you want figures that are between two set values to go a certain colour, then use the Conditional Formatting tool. Conditional Formatting allows you to add colour to a spreadsheet based on a condition. 

Just go to the Home tab > Conditional Formatting > Highlight Cell Rules > Between.

Type in the figures that are going to be your upper and lower limit, e.g. if you want all numbers between 20 and 40 to be formatted, then type 20 and 40 into the condition boxes. 

Finally select a colour that you want the cell(s) to change to.

You can use the Conditional Formatting tool to change a cells colour if the value is equal to a specified value. 

Just go to the Home tab > Conditional Formatting > Highlight Cell Rules > Equal To.

Type in the figure that you want the values to be equal to, e.g. if you want all numbers that are equal to 30 to be formatted, then type 30 into the condition box.

Finally select a colour that you want the cell(s) to change to.

Do you want to clearly see the variation of a range of figures? Then how about using a heat map. All you do is select the figures you want to include and go to the Home tab > Conditional Formatting > Colour Scales and select one of the options available to you.

You will now be able to see where the lower and higher values of your data are.