"carrera" wrote:

In cells B1:B47 are times in decending order, military time. (23:30, 23:00,
22:30.....:30)

I've set up the sheets so I can enter Start time in C50 and end time in C51
and the cells next to the appropriate times in B will get an "X" and turn
green. ie =IF(C$50$B30,""IF(C$51=$B30"X","")) and CF to turn cells with an
X green.

In C59 I have the formula =COUNTIF(C2:47,"X") and in C60 I have
=NameofPriorSheet!C60=C59 to get a running total of X's....thus 80 X's equals
40 hours worked, anything over is overtime.

My Question - I need to add a 2nd Conditional Formating to turn Only the
cells with an "X" AND represent cells that put the COUNTA of X's over 80 to
turn RED. Also, the cells would have to be the lesser numbered rows.

For instance - On one sheet the COUNTA of X's is 86 and cells C12 through
C21 have X's in green cells. I need the X's in cells C12 through C17 to turn
Red, with an X.



Before I answer this question there are two things I must know.

1. Are you getting paid to do this?

2. Why are you reinventing the wheel?

There must be a gazillion templates floating around for timekeeping. I know
it's fun to make your own but if we solve the problem for you, then you don't
have any fun, do you?

B+
HALinNY