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