software

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


With B12 as active cell: Format | Conditional Formatting
Condition1:
Formula Is =B10gt;=B11 set colour to green
Add
Condition2
Formula Is =B10gt;=B11-10% set colour to yellow
(I am guessing 75% was arrived at as 85%-10points)
Add
Condition3
Formula Is B10lt;B11-10%
OK

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;paule1982quot; gt; wrote in message
...
gt; Here's an example of what I mean and you may understand it better:
gt;
gt; B10 = 73% appraisals completed
gt; B11 = 85% appraisal target
gt;
gt; If B10 is equal to or greater than 85% then I need excel to fill in B12 in
gt; the colour green
gt;
gt; then if B10 is betwen 84% and 75% then I need B12 to be filled in amber
gt;
gt; and if B10 is equal to or less than 74% then I need B12 to be filled in
gt; red
gt;
gt; I really hope this makes sense to someone.
gt;
gt; Thanks
cond 1 formula is =b10gt;85
cond 2 formula is =b10gt;74
cond 3 formula is =b10gt;0

--
Don Guillett
SalesAid Software

quot;paule1982quot; gt; wrote in message
...
gt; Hi,
gt;
gt; This is a strange one, and if anyone can shed any light on my predicament
gt; I'd be overjoyed...
gt;
gt; I need excel to compare a percentage value against another percentage
gt; value
gt; that I have entered (e.g. an actual result vs target result).
gt;
gt; I then want excel to fill a cell one of three colours depending on the
gt; result...
gt;
gt; Here's an example of what I mean and you may understand it better:
gt;
gt; B10 = 73% appraisals completed
gt; B11 = 85% appraisal target
gt;
gt; If B10 is equal to or greater than 85% then I need excel to fill in B12 in
gt; the colour green
gt;
gt; then if B10 is betwen 84% and 75% then I need B12 to be filled in amber
gt;
gt; and if B10 is equal to or less than 74% then I need B12 to be filled in
gt; red
gt;
gt; I really hope this makes sense to someone.
gt;
gt; Thanks
click b12
select format--gt;conditional formatting
Below quot;condition 1quot; select quot;Formula isquot;
in the box next to it type: =B10gt;=0,85
click Format
click quot;Patternsquot;
select the colour you want
click ok
click quot;Addquot; (at the bottom)
Repeat the process for conditions 2 and 3 with these entries
=AND(B10gt;0,74;B10lt;0,84)
=B10lt;=0,74
click ok

HansWhat you need is Conditional Formatting.

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

for each conditions click on Format and select your color

HTH
Jean-Guy

quot;paule1982quot; wrote:

gt; Hi,
gt;
gt; This is a strange one, and if anyone can shed any light on my predicament
gt; I'd be overjoyed...
gt;
gt; I need excel to compare a percentage value against another percentage value
gt; that I have entered (e.g. an actual result vs target result).
gt;
gt; I then want excel to fill a cell one of three colours depending on the
gt; result...
gt;
gt; Here's an example of what I mean and you may understand it better:
gt;
gt; B10 = 73% appraisals completed
gt; B11 = 85% appraisal target
gt;
gt; If B10 is equal to or greater than 85% then I need excel to fill in B12 in
gt; the colour green
gt;
gt; then if B10 is betwen 84% and 75% then I need B12 to be filled in amber
gt;
gt; and if B10 is equal to or less than 74% then I need B12 to be filled in red
gt;
gt; I really hope this makes sense to someone.
gt;
gt; Thanks