lock one cell when data in another

[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

 

[tjb]

OK that works great!

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

TIA