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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top