If you have protected a worksheet, how can you highlight an unprotected cell on that worksheet?
Q Questionable Jun 16, 2005 #1 If you have protected a worksheet, how can you highlight an unprotected cell on that worksheet?
D Dave Peterson Jun 16, 2005 #2 Are you Dave? You could use Format|Conditional formatting. Select your range (I used A1:X99) then with A1 the active cell Format|conditional formatting formula is: =CELL("protect",A1)=0 Format it nicely. If you're Dave, you have a response at your first version of this post.
Are you Dave? You could use Format|Conditional formatting. Select your range (I used A1:X99) then with A1 the active cell Format|conditional formatting formula is: =CELL("protect",A1)=0 Format it nicely. If you're Dave, you have a response at your first version of this post.
