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!

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!