I don't believe you can protect just one cell the way you described. You
have to protect the entire sheet and then unlock those cells that you want to
allow editing in.

"Anner" wrote:

I want to protect a given cell if the contents of another cell is "Conf". I
can record a macro to Format-Cell-Protection-Locked, but how do I combine
that with the conditional IF? Thanks very much!