hey all,
I work for a fulfillment center and have to rates of very person in my area of ownership, to help them reach their productive goals. I am trying to create a sheet that will highlight everyone that's hitting under their rate but because there is a learning curve and not everyone has to meet the same rates I cannot simply do a less than greater than scenario. I need each persons rate expectation to be in line with their learning curve. for example: if sally joe is in her first week her learning curve is 60 units an hour, but joe bagah is week 2 he should be producing 67 units an hour, and so on a so for. I need a formula or way of formatting this to so that if sally joe hits above 60 but below 67 she wont show red but joe baggah would. the way I have the sheet set up is to list their learning curve next to their rate, so I need a way for the rate cells format to look at the adjacent cell and determine if it should be formatted.
I work for a fulfillment center and have to rates of very person in my area of ownership, to help them reach their productive goals. I am trying to create a sheet that will highlight everyone that's hitting under their rate but because there is a learning curve and not everyone has to meet the same rates I cannot simply do a less than greater than scenario. I need each persons rate expectation to be in line with their learning curve. for example: if sally joe is in her first week her learning curve is 60 units an hour, but joe bagah is week 2 he should be producing 67 units an hour, and so on a so for. I need a formula or way of formatting this to so that if sally joe hits above 60 but below 67 she wont show red but joe baggah would. the way I have the sheet set up is to list their learning curve next to their rate, so I need a way for the rate cells format to look at the adjacent cell and determine if it should be formatted.