| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditionally highlight unprotected cells
Is there a way in Excel 2007 to automatically highlight or format all
unprotected cells? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditionally highlight unprotected cells
hi, Bob !
Is there a way in Excel 2007 to automatically highlight or format all unprotected cells? try with conditional fomat (by formula) using the activecell as reference w/ cell(...) function (i.e.) =cell("protect",a1)=0 hth, hector. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditionally highlight unprotected cells
Thanks, Héctor, that works great!
"Héctor Miguel" wrote: hi, Bob ! Is there a way in Excel 2007 to automatically highlight or format all unprotected cells? try with conditional fomat (by formula) using the activecell as reference w/ cell(...) function (i.e.) =cell("protect",a1)=0 hth, hector. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditionally highlight unprotected cells
Thanks, Héctor, that works great!
"Héctor Miguel" wrote: hi, Bob ! Is there a way in Excel 2007 to automatically highlight or format all unprotected cells? try with conditional fomat (by formula) using the activecell as reference w/ cell(...) function (i.e.) =cell("protect",a1)=0 hth, hector. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing Unprotected Cells Only | Excel Discussion (Misc queries) | |||
| tab between unprotected cells | Excel Discussion (Misc queries) | |||
| Modifying UnProtected Cells | Excel Discussion (Misc queries) | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
| Unprotected cells after a download | Excel Discussion (Misc queries) | |||
Linear Mode
