Conditional Formating & COUNTA
 

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.