| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting
you guys rock
"Bernard Liengme" wrote: Forgot to add: Use Format|Conditional Format and in the ensuing dialog box use: Formula is =CELL("protect",A1)=1 ****** and set the colour needed****** -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Bernard Liengme" wrote in message ... Select the entire worksheet by clicking the empty area where the row and column headers meet in the top left of the workspace Use Format|Conditional Format and in the ensuing dialog box use: Formula is =CELL("protect",A1)=1 Of course this must be done before protection is switched on! best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "steve" wrote in message ... for a particular worksheet, if a cell is locked, i want it to be filled in with a color. How can this be accomplished? Thank you, Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Hybrid Mode
