lock one cell when data in another

  • Thread starter Thread starter dh
  • Start date Start date
D

dh

You can do it by formula using data validation without the
need for VBA
data|validation| use the drop down to select Custom
in the formula box enter =if(g15<>0,0)
then add a message that you want displayed

dave
 
OK that works great!

now how about having no data entry capability in cell G15
or I15 if cell C15 is blank

TIA
 
Back
Top