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!
From Italy
6I 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!
From Italy
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
Cell : 9881468743.
From India, Mumbai
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
Cell : 9881468743.
From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Time Sheet 1.0.zip
Time sheet.xls