By default all cells on the sheet are locked, locked status is only relevant
if the sheet is protected. If the sheet is protected you may (depending on
protect options) need to unprotect before trying Gary's or Dave's
suggestions. If that's not possible you could loop through cells checking if
Not .Locked and apply some format to the unlocked cells.

Regards,
Peter T

"scott" wrote in message
...
I just inherited a very large legacy spreadsheet that has a good bit of
locked cells throughout. Is there a way to maybe iterate through a page
and
highlight or other formating of just cells that are locked?

It's very time-consuming to manually check a lot of cells to see if they
have been locked.