To simplify my problem, I will narrow down the results.

The result of a calculation is shown as a percentage. Is it possible to
format the cell to display the result in different colours dependant on it's
value?

Example:
Below 50% - White background, green text
50% and over - Yellow background and red text.