input value in a cell when the previous cell is greater than 0

V

vinod

The cell reference say L11 should only be allowed to key in the value if the
total of K11 is greater than 0.
 
P

Peo Sjoblom

Select L11, do data>validation, allow custom and use

=$K$11>0

won't prevent someone from copying and pasting, only keying

Regards,

Peo Sjoblom
 
Top