Home |
Search |
Today's Posts |
#1
|
|||
|
|||
input value in a cell when the previous cell is greater than 0
The cell reference say L11 should only be allowed to key in the value if the
total of K11 is greater than 0. |
#2
|
|||
|
|||
Select L11, do datavalidation, allow custom and use
=$K$110 won't prevent someone from copying and pasting, only keying Regards, Peo Sjoblom "vinod" wrote: The cell reference say L11 should only be allowed to key in the value if the total of K11 is greater than 0. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
how do i make a cell date sensitive to execute a formula or input. | Excel Discussion (Misc queries) | |||
How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
How would I fill blank cells with the data from a previous cell? | Excel Discussion (Misc queries) | |||
Can I retain functions from a previous cell when inserting a new r | Excel Discussion (Misc queries) |