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.