Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula
Need help with a formula. (Excel 2003)
Need to create a conditional formula to identify spending trends. Example: A1= Alocated Budget, A2-A5= Spending Breakdown, A6= Total Actual Spent If A6 is 50% or less than A1, flag "Green" If A6 is 51% or greater than A1, flag "Red" Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula
Hi,
Select A6 then Format|Conditional format Cell value is Less than =$A$1/2 select green Ok Click ADD and repeat but this time use 'greater than equal to' select red Mike "David" wrote: Need help with a formula. (Excel 2003) Need to create a conditional formula to identify spending trends. Example: A1= Alocated Budget, A2-A5= Spending Breakdown, A6= Total Actual Spent If A6 is 50% or less than A1, flag "Green" If A6 is 51% or greater than A1, flag "Red" Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula
How is it identifing the cell to compare to?
I am working across a row, not down a column, does this make a difference? This one has got me stumped! I need "I3" to flag if it is greater or less than 50% of "D3" Thanks for the help, David "Mike H" wrote: Hi, Select A6 then Format|Conditional format Cell value is Less than =$A$1/2 select green Ok Click ADD and repeat but this time use 'greater than equal to' select red Mike "David" wrote: Need help with a formula. (Excel 2003) Need to create a conditional formula to identify spending trends. Example: A1= Alocated Budget, A2-A5= Spending Breakdown, A6= Total Actual Spent If A6 is 50% or less than A1, flag "Green" If A6 is 51% or greater than A1, flag "Red" Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula
Probably "less than or equal" and then "greater than".
[The OP wanted 50% to be green.] -- David Biddulph "Mike H" wrote in message ... Hi, Select A6 then Format|Conditional format Cell value is Less than =$A$1/2 select green Ok Click ADD and repeat but this time use 'greater than equal to' select red Mike "David" wrote: Need help with a formula. (Excel 2003) Need to create a conditional formula to identify spending trends. Example: A1= Alocated Budget, A2-A5= Spending Breakdown, A6= Total Actual Spent If A6 is 50% or less than A1, flag "Green" If A6 is 51% or greater than A1, flag "Red" Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula
David,
You've got me confused now. In your original post you said If A6 is 50% or less than A1, flag "Green" If A6 is 51% or greater than A1, flag "Red" So my formula compared A6 to 1/2 of A1 If you want to compare I3 to 50% of D3 then it's the same as before with the references changed So select I3 and enter the conditional format =$D$3/2 Mike "David" wrote: How is it identifing the cell to compare to? I am working across a row, not down a column, does this make a difference? This one has got me stumped! I need "I3" to flag if it is greater or less than 50% of "D3" Thanks for the help, David "Mike H" wrote: Hi, Select A6 then Format|Conditional format Cell value is Less than =$A$1/2 select green Ok Click ADD and repeat but this time use 'greater than equal to' select red Mike "David" wrote: Need help with a formula. (Excel 2003) Need to create a conditional formula to identify spending trends. Example: A1= Alocated Budget, A2-A5= Spending Breakdown, A6= Total Actual Spent If A6 is 50% or less than A1, flag "Green" If A6 is 51% or greater than A1, flag "Red" Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula
You may be correct but now we seem to have gone from comparing A6 to 50%*A1
to a completely different set of references!! "David Biddulph" wrote: Probably "less than or equal" and then "greater than". [The OP wanted 50% to be green.] -- David Biddulph "Mike H" wrote in message ... Hi, Select A6 then Format|Conditional format Cell value is Less than =$A$1/2 select green Ok Click ADD and repeat but this time use 'greater than equal to' select red Mike "David" wrote: Need help with a formula. (Excel 2003) Need to create a conditional formula to identify spending trends. Example: A1= Alocated Budget, A2-A5= Spending Breakdown, A6= Total Actual Spent If A6 is 50% or less than A1, flag "Green" If A6 is 51% or greater than A1, flag "Red" Thanks |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula
The way it is identifying the cell with which to compare is:
"Cell value is Less than =$A$1/2" We'll leave you to work out what to do to compare with 50% of D3. -- David Biddulph "David" wrote in message ... How is it identifing the cell to compare to? I am working across a row, not down a column, does this make a difference? This one has got me stumped! I need "I3" to flag if it is greater or less than 50% of "D3" Thanks for the help, David "Mike H" wrote: Hi, Select A6 then Format|Conditional format Cell value is Less than =$A$1/2 select green Ok Click ADD and repeat but this time use 'greater than equal to' select red Mike "David" wrote: Need help with a formula. (Excel 2003) Need to create a conditional formula to identify spending trends. Example: A1= Alocated Budget, A2-A5= Spending Breakdown, A6= Total Actual Spent If A6 is 50% or less than A1, flag "Green" If A6 is 51% or greater than A1, flag "Red" Thanks |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula
Thank you both for your help. Sorry for the confusion. I knew what I needed,
just needed to figure out how to ask. Thanks "Mike H" wrote: You may be correct but now we seem to have gone from comparing A6 to 50%*A1 to a completely different set of references!! "David Biddulph" wrote: Probably "less than or equal" and then "greater than". [The OP wanted 50% to be green.] -- David Biddulph "Mike H" wrote in message ... Hi, Select A6 then Format|Conditional format Cell value is Less than =$A$1/2 select green Ok Click ADD and repeat but this time use 'greater than equal to' select red Mike "David" wrote: Need help with a formula. (Excel 2003) Need to create a conditional formula to identify spending trends. Example: A1= Alocated Budget, A2-A5= Spending Breakdown, A6= Total Actual Spent If A6 is 50% or less than A1, flag "Green" If A6 is 51% or greater than A1, flag "Red" Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
Conditional Formula to indicate Formula in cell | New Users to Excel | |||
conditional formula in every third row and last row. | Excel Worksheet Functions | |||
Formula for conditional "ifs"? | New Users to Excel |