G
Guest
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
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