USE OF "PROTECT" FORUMLA

[sachar]

Dear All,

With reference to the attachment applied the formula "Cell ('protect', B1937)=0" in conditional formatting.

Please help to know the use of this formula.
Thanking you

 

[NARAYANK991]

Hi ,

A cell which has its Locked checkbox checked will return the value 1 ; one which has its Locked checkbox unchecked will return the value 0.

See the following for its application :

http://www.excel-university.com/format-locked-or-unlocked-cells/

Narayan