Find Protected Cells
Use Conditional Formatting to select Formula is.
Then enter
=CELL("Protect",A1)=1
and Format as you like.
Change range to suit.
© Copyright
andrewsexceltips.net
All Rights Reserved.