S
Sdbenn90
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.
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.