Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
If you have protected a worksheet, how can you highlight an unprotected cell
on that worksheet? |
#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. Questionable wrote: If you have protected a worksheet, how can you highlight an unprotected cell on that worksheet? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
Possible Lookup Table | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |