What you need is Conditional Formatting.

Select B12, then go to Format/Conditional Formatting, select "Formula is"
from the drop down menu and in the formula box type:
=B10<75%
next click on ADD, again "Formula is" and:
=B10=85%
or if you need the formula to look at B11 instead type:
=B10=B11
click on ADD "Formula is" :
=AND(B10=75%,B10<85%)
or
=AND(B10=75%,B10<B11)

for each conditions click on Format and select your color

HTH
Jean-Guy

"paule1982" wrote:

Hi,

This is a strange one, and if anyone can shed any light on my predicament
I'd be overjoyed...

I need excel to compare a percentage value against another percentage value
that I have entered (e.g. an actual result vs target result).

I then want excel to fill a cell one of three colours depending on the
result...

Here's an example of what I mean and you may understand it better:

B10 = 73% appraisals completed
B11 = 85% appraisal target

If B10 is equal to or greater than 85% then I need excel to fill in B12 in
the colour green

then if B10 is betwen 84% and 75% then I need B12 to be filled in amber

and if B10 is equal to or less than 74% then I need B12 to be filled in red

I really hope this makes sense to someone.

Thanks