I 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!

Do a search here for multiple conditional formats and you will get a lot.
More that 3, sometimes 4 you will have to use code, you can also look into
sort/count by color, as this will answer the last part of your question.
Check out bob's site for all kinds of good stuff especially for this case the
easy filter
http://www.rondebruin.nl/
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"rstruhs" wrote:

I 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!