select cells that sum up to a specific value
Hi,
good questions,
With our list of production orders, we know that the next day the
production line will be able to handle $10,000.00 worth of work, when a
user selects a range, inputs the value, and the rows with the cells
that total $10,000.00 will change color. I say (as close to), because
there are cents to deal with and not all orders have the same value...
JLatham wrote:
This could be ugly. Could we have some more rules for this game? ..........
"damorrison" wrote:
I would like to highlite a range, then
click a button for an input box that asks for a value
then the rows with the cells that add up to that value(or as close to
it), will change to blue,
Has anybody an example of this or know of a way for this to be done??
Thanks
Dave
|