Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Help
I need help with a function that will do the following. Based on the level, a
specific number of unit will be assigned to that level and the summed . In this case Level one can complete 48-59 units. Can I check the summed total to make sure it is in the range for a level one? Col A Col B Level 1 22 <--Units 22 12 56 <--Summed total of the above units in this example for level 1, 56 does fall between 48-59 i could use true or false but ultimately i like to color the summed total green if it falls between the range for that level or red if it does not. Any help will be greatly appreciated. Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Help
You can use conditional formatting
Assuming the sum cell is say, B6 Select B6, then apply CF using Formula is: Condition 1: =AND(B6=48,B6<=59) Format: Green Condition 2: =OR(AND(B60,B6<48),B659) Format: Red Click to OK out -- Max Singapore http://savefile.com/projects/236895 Downloads:20,000 Files:362 Subscribers:62 xdemechanik --- "Sdbenn90" wrote: I need help with a function that will do the following. Based on the level, a specific number of unit will be assigned to that level and the summed . In this case Level one can complete 48-59 units. Can I check the summed total to make sure it is in the range for a level one? Col A Col B Level 1 22 <--Units 22 12 56 <--Summed total of the above units in this example for level 1, 56 does fall between 48-59 i could use true or false but ultimately i like to color the summed total green if it falls between the range for that level or red if it does not. Any help will be greatly appreciated. Thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Help
Worked Great, Thanks. However I have 6 different levels. Depending on the
level (1-6) if the summed total is between the appropriate level. "Max" wrote: You can use conditional formatting Assuming the sum cell is say, B6 Select B6, then apply CF using Formula is: Condition 1: =AND(B6=48,B6<=59) Format: Green Condition 2: =OR(AND(B60,B6<48),B659) Format: Red Click to OK out -- Max Singapore http://savefile.com/projects/236895 Downloads:20,000 Files:362 Subscribers:62 xdemechanik --- "Sdbenn90" wrote: I need help with a function that will do the following. Based on the level, a specific number of unit will be assigned to that level and the summed . In this case Level one can complete 48-59 units. Can I check the summed total to make sure it is in the range for a level one? Col A Col B Level 1 22 <--Units 22 12 56 <--Summed total of the above units in this example for level 1, 56 does fall between 48-59 i could use true or false but ultimately i like to color the summed total green if it falls between the range for that level or red if it does not. Any help will be greatly appreciated. Thanks in advance. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Help
"Sdbenn90" wrote:
Worked Great, Thanks. Good to hear. Take a moment to press the Yes button (like the ones below) in that response which helped, won't you? However I have 6 different levels. Depending on the level (1-6) if the summed total is between the appropriate level. That's a different ballgame. Suggest you try a new posting in .programming. -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:363 Subscribers:64 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |