Conditional Formatting

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!!
 
J

Jim Thomlinson

Just colour the cell amber and avoid the conditional format. If one of the
Conditional Format conditions are met then it will override the colour.
Otherwise it will leave the cell amber...
 
R

Ron@Buy

Whilst Jim is 100% correct, for future reference the formula you seek for
amber could be: =AND(I6>80%,I6<99.999%)
 
L

Lynn Ash

That is fantastic!

Thanks so much for your help - I knew something was missing!!

Kind regards
 
Top