I am trying to build a form in excel 2007 and make it so that you can only fill in certain cells based on answers previously entered.
Basically I want a given cell to be protected or unprotected based on wether or not another cell has been used.
I assume this would be done using if statments but Im not sure.
any ideas?
Bookmarks