Hello -
I have a spreadsheet that is used for data entry. I have added conditional formatting that when someone enters a number into the cell, it turns red, yellow or green depending on the value entered. I want to be able to lock everything on the spreadsheet (conditional formatting & changing the spreadsheet setup) except for the data entry into that cell and a comments cell. I would like it so that all the operator can do is enter the value and enter comments into the cell next to it. I've searched and played with the protect sheet options but haven't had any luck yet. Can someone help me? Thank you!
Bookmarks