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.