| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Marking Protected Celss
Is there a way to mark protected cells by automatically creating a colored or
patterned background for the protected cell? -- Thanks, WW |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Marking Protected Celss
W Wolfe
Select the range/sheet you want colored. GotoFormatConditional formating. Select "Formula Is" and enter: =CELL("Protect",A1) select "Format" and place a nice format through the options available Ok out. Instead of "A1" in your formula you will use the active cell in you selection. I hope this helps Mike Rogers "W Wolfe" wrote: Is there a way to mark protected cells by automatically creating a colored or patterned background for the protected cell? -- Thanks, WW |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change row color based on condition of celss | Excel Worksheet Functions | |||
| Copy only celss with text not blanks | Excel Discussion (Misc queries) | |||
| Adding data to celss but keeping the remaining data intact. | Excel Discussion (Misc queries) | |||
| Marking rows | Excel Discussion (Misc queries) | |||
| Marking Duplicates | Excel Worksheet Functions | |||
Linear Mode
