More than 3 conditional statements or macro or ??

[Guest]

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!

 

[Bob Phillips]

http://www.xldynamic.com/source/xld.CFPlus.Download.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)