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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 data>validation, allow custom and use

=$K$11>0

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

Regards,

Peo Sjoblom
 
Back
Top