I am trying to colour code some figures into Green, Amber & red relating to
what percentage has been achieved.

In the following example I have got the red (under 80% working and the Green
(over 100% but I CANNOT get the formula right for the amber section.

=I6100% Green

=I680%<99.999% Amber

=I6<79.9999 Red

Please can someone help - I am sure it is going to be sooo easy once someone
tells me what I am doing wrong!

I hope someone can help soon as it is driving me mad!!
--
Lynn