Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating is greyed out and unavailable | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
excel conditional formating decimal fractions | Excel Worksheet Functions | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) |