Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
select a range using "cells()" | Excel Worksheet Functions | |||
How do I unlock specific cells in a spreadsheet that I protected? | Excel Discussion (Misc queries) | |||
Locate and delete specific cells | Excel Discussion (Misc queries) |