More than 3 conditional statements or macro or ??
have a spreadsheet where the cells are formated for time. I have set up 3
conditional formating formulas, (1) colors the cell gray if it is a weekend, (2) colors the cell green if it is a US holiday, (3) colors the cell yellow if the value in it indicates the person was more than 3 minutes late for work. My boss wants to make the following additions: if the person is sick the cell is pink, if the person is on vacation is it orange, if the person takes a personal day it is light blue, if the person is taking FMLA it is purple. And he wants to be able to enter a number in hours for that event (ie., FMLA = 4 hours, vacation = 8 hours, sick = 2 hours, etc.) Any ideas anyone? Is there some VB code I could use? How would I test for FMLA vs. vacation vs personal, etc.? Next questions will be regarding how to total each category. Thanks for your help! |
More than 3 conditional statements or macro or ??
http://www.xldynamic.com/source/xld.....Download.html
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "rstruhs" wrote in message ... have a spreadsheet where the cells are formated for time. I have set up 3 conditional formating formulas, (1) colors the cell gray if it is a weekend, (2) colors the cell green if it is a US holiday, (3) colors the cell yellow if the value in it indicates the person was more than 3 minutes late for work. My boss wants to make the following additions: if the person is sick the cell is pink, if the person is on vacation is it orange, if the person takes a personal day it is light blue, if the person is taking FMLA it is purple. And he wants to be able to enter a number in hours for that event (ie., FMLA = 4 hours, vacation = 8 hours, sick = 2 hours, etc.) Any ideas anyone? Is there some VB code I could use? How would I test for FMLA vs. vacation vs personal, etc.? Next questions will be regarding how to total each category. Thanks for your help! |
All times are GMT +1. The time now is 12:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com