Is there a method whereby I can lock a data validation list if certain cells have a value >0. In accomplishing this I still need the drop down list available for rows that remain blank.

I.E. Column J has a data validation list with three items. Based upon the selection in the drop down I have sent data to three tabs. I have eliminated double entries and blank rows on each tab. Data is then entered on the selected tabs by tab. The system works great; however, if someone (and I know they will) changes one of three choices on the drop down list when data has been entered on the tabs the data on the tab that is prefilled based upon the drop down shifts up (to fill the blank) making the data entered on just the tabs appear on the wrong row.