Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |