Time Sheet Formula Problem - Xls Download

Dear Friends,
I am using a time sheet in my office which is attached.
I have formula problem for the days. Off days are colored, when you change Month No. on Month sheet, the colored columns change their places according to the month days.
My problem is how can I change this Friday to Saturday, or how can do it to both Friday and Saturday?
Please instruct me the formula!
Many thank in Advance!

Hi Parwiz,
I have checked your problem.
Please find below the solution.
a) To Change the colour from Friday to Saturday :
1. Go to cell C11 in Sheet Hammad
2. Select 'Format' -> 'Conditional Formation' (Alt+O+D)
3. Change the formula from 'Fr' to 'Sa'
4. Click on 'OK'
5. Now copy the cell 'C11' and Paste to 'C11:AH15'
b) To Change the colour for both Friday & Saturday :
1. Follow 1 & 2 above.
2. Click on Add>> button.
3. Select 'Formula Is'
4. Type the formula =C$9='sa'
5. Click on 'Format' button and select the Pattern / Font colour required.
6. Click on 'OK'
7. Now copy the cell 'C11' and Paste to 'C11:AH15'
I hope this will help.
Regards,
Santosh Gaikwad
[Login to view]
Cell : 9881468743.

Hi Santhosh,
Pls tel me that protect the particular cell. if whole data is there but i want to protect the particular cell how?
Rajesh
9710883087