L
Lynn Ash
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.
=I6>100% Green
=I6>80%<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!!
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.
=I6>100% Green
=I6>80%<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!!