| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
colour of protected cells
Hello all
I would like to set up excel so that if a cell or a range is protected it will be displayed in a different colour. Can any one tell me how to do this. regards from south africa |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
colour of protected cells
Hi Fred,
Use conditional formatting. Select the worksheet range, starting from cell A1. Then set the "Formula is" format to =CELL("protect",A1) and the format to a pattern fill. Ed Ferrero www.edferrero.com Hello all I would like to set up excel so that if a cell or a range is protected it will be displayed in a different colour. Can any one tell me how to do this. regards from south africa |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting cells according to their colour | Excel Discussion (Misc queries) | |||
| paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
| Will excel add cells using colour coding eg Add all red cells | Excel Discussion (Misc queries) | |||
| Accont cells with colour? | Excel Discussion (Misc queries) | |||
| Adding colour to a range of cells based on one of the cells v... | Excel Discussion (Misc queries) | |||
Hybrid Mode
