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.

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.