Marking Protected Celss

  • Thread starter Thread starter W Wolfe
  • Start date Start date
W

W Wolfe

Is there a way to mark protected cells by automatically creating a colored or
patterned background for the protected cell?
 
W Wolfe

Select the range/sheet you want colored.
Goto>Format>Conditional 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ignore blank celss in left function 2
how to replace an unrecognised character 2
PROTECTING CELLS 2
Cell Protection? 2
How do I make a rank equation that omits particular cells? 1
Copying All Cells in XL 2007 4
Autofilter not working on protected sheet. 1
Copy and paste color 3

Back
Top