Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTA Conditional Formating question
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. whew. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format question | Excel Discussion (Misc queries) | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
can i freeze conditional formating to copy to another worksheet | Excel Discussion (Misc queries) | |||
IF Command conditional formating | Excel Worksheet Functions | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) |