Hello,
I am creating a sheet to trend data for testing of a specific product in my lab. The last column of my data table is a column for the person reviewing the data for accurate transcription to initial that they have completed the review for that batch. If there a way to have that line of cells lock once someone has entered anything in that column? I'm thinking of something along the lines of a condition where if the cell in that column for each line is not blank then the line is locked if that makes sense. Not sure how to do this though. I just want to make sure that once the data has been reviewed it is protected from accidental changes.
Thanks for any help anyone can offer.