Google Spreadsheet conditional formatting for week days check (display weekends with a different color)

Goal: 

I have a column of dates that I want to format so that weekends are in a different color. 

Solution :  

conditional formatting and the formula =OR(WEEKDAY(A1)=7;WEEKDAY(A1)=1) 

OpenOffice / oocalc : protect specific cells

The problem :

I've got a calc sheet for calculating some grades.
Hence, after setting all the formulas (you may want to have a look at the SUMPRODUCT(notes*percent) function ;-) ), I want to actually enter the grades I gave.

What I want to do is not to mess around with the cell containing formulas while I am entering data.

How to (un)-lock specific cells

1. Select the cell you want to still modify.


2. right-click: Format-Cells -> "Cell Protection" tab => uncheck "protected".


3. Tools -> Protect Document -> sheet


4. Uncheck "select locked cells" and check "select unlocked cells".

Now only the cells selected in step 1) should be the only ones you can select and modify !