#1   Report Post  
Posted to microsoft.public.excel.misc
paule1982
 
Posts: n/a
Default If statements

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default If statements


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

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

"paule1982" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.excel.misc
flummi
 
Posts: n/a
Default If statements

click b12
select format--conditional formatting
Below "condition 1" select "Formula is"
in the box next to it type: =B10=0,85
click Format
click "Patterns"
select the colour you want
click ok
click "Add" (at the bottom)
Repeat the process for conditions 2 and 3 with these entries
=AND(B100,74;B10<0,84)
=B10<=0,74
click ok

Hans

  #5   Report Post  
Posted to microsoft.public.excel.misc
pinmaster
 
Posts: n/a
Default If statements

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
UDFunctions and nested If-the-else statements JDB Excel Worksheet Functions 1 January 25th 06 03:29 PM
How do I sum percentages calculated from IF statements? Rusty T Excel Worksheet Functions 3 November 9th 05 10:02 PM
Linking two IF statements together trixma Excel Discussion (Misc queries) 2 September 29th 05 06:07 AM
Better Way to Code IF Statements? TheRobsterUK Excel Discussion (Misc queries) 4 July 18th 05 03:37 PM
Nested IF statements John Simons Excel Worksheet Functions 14 February 16th 05 06:17 AM


All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"