Filter for cells by locked/unlocked status

  • Thread starter Thread starter Denise
  • Start date Start date
You might add a helper column with the "Cell" function:

=CELL("protect",D12)

It will return 0 for a protected cell and 1 for
unprotected.

Good Luck

Mike
 
Back
Top