Excel Worksheets

first unprotect all

set format cells->protection->locked for all the cells except for the yellow cells

now protect the worksheet. your need will be done!

thanks,
bala

Can't find set format cells...

select all cells

right click

select "Format cells"

select the last tab "protection"

Let's try it a different way if you could.

1) protect the entire sheet.
2) unprotect those cells that are yellow.

How do I do that?

to protect cell level, u have to set the option i had mentioned.

select entire sheet.

right click

select "Format cells"

select the last tab "protection"

check in "Protected"

now select the column u want to unprotect

check out "Protected"

now protect the entire worksheet.

this protects those cells that has "Protected" and leaves out those dont have.

So there isn't a way to set up something in excel that when I select Protect and Unprotect, it knows to protect any cell that is not yellow.  I have to go thru this routine described above each time I want to protect it.

I want to highlight the yellow cells and click on a protect button...that is my specific question.

I figured it out...Just click on one of the top yellow sales.

Then Review>Changes>Protect Sheet>
Click on Select Unlocked Cells

Works like a champ!!

THanks again!

cool! it should have been by default on your worksheet. select locked cells & select unlocked cells.

great..

enjoy!!!