Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Attendance Tracking
Hi,
me try to follow a rule for all the employees of in my concern. e.g., Working Hrs for all the employee is 9:30hrs to 18:45hrs. If any one works till 20:30hrs in a day he or she can resume his next day's duty by 10:30hrs in the mornining. But if he or she has work less than 20:30 hrs then he has resume his duty from 9:30hrs in the morning. To ascertain this i created an excel sheets. All the Columns (C1,E1,G1,I1,K1,M1,O1,P1....) has got time In All the Columns (D1,F1,H1,J1,L1,N1,P1,Q1....) has got time out. Now i want that if D1 is greater than or equal to 20:30 hrs it should automatically becomes Bold otherwise it should be in normal fonts (without Bold). Moreover if D1 greater than 20:30hrs then E1 can have data in normal font only till 10:30hrs. As soon as the user enters data greater than 10:30hrs in D1 it should automatically change the font color in Red with strikethrough. This would continue in all the cell (D1,F1,H1,J1,L1,N1,P1,Q1....) How can this be possible. I dont want to run macro all the time. It should work autometically in the back end. Awaiting for your reply. Thanks Akash |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Attendance Tracking
You should be able to do this without macros. Try using conditional
formatting. -- JNW "Akash" wrote: Hi, me try to follow a rule for all the employees of in my concern. e.g., Working Hrs for all the employee is 9:30hrs to 18:45hrs. If any one works till 20:30hrs in a day he or she can resume his next day's duty by 10:30hrs in the mornining. But if he or she has work less than 20:30 hrs then he has resume his duty from 9:30hrs in the morning. To ascertain this i created an excel sheets. All the Columns (C1,E1,G1,I1,K1,M1,O1,P1....) has got time In All the Columns (D1,F1,H1,J1,L1,N1,P1,Q1....) has got time out. Now i want that if D1 is greater than or equal to 20:30 hrs it should automatically becomes Bold otherwise it should be in normal fonts (without Bold). Moreover if D1 greater than 20:30hrs then E1 can have data in normal font only till 10:30hrs. As soon as the user enters data greater than 10:30hrs in D1 it should automatically change the font color in Red with strikethrough. This would continue in all the cell (D1,F1,H1,J1,L1,N1,P1,Q1....) How can this be possible. I dont want to run macro all the time. It should work autometically in the back end. Awaiting for your reply. Thanks Akash |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tracking Attendance | Excel Discussion (Misc queries) | |||
Need to create attendance tracking based on % and 2080 hours/year | Excel Discussion (Misc queries) | |||
moving quarter attendance tracking | Excel Discussion (Misc queries) | |||
Attendance tracking | Setting up and Configuration of Excel | |||
How do I track half days in the attendance tracking template? | Excel Discussion (Misc queries) |