Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
How do I sum percentages calculated from IF statements? | Excel Worksheet Functions | |||
Linking two IF statements together | Excel Discussion (Misc queries) | |||
Better Way to Code IF Statements? | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions |