Got a bit of a question. Trying to sort out some spreadsheets at work, and I'm somewhat figured most of the formula's out. But the sheets are rolling on from each other.
As seen below, O11 grabs the information from the previous sheet, but because there's a formula in O, the formula in S and U think that cell O is not blank. Is there a workaround to this? Let me know if I need to explain myself more.
As seen below, O11 grabs the information from the previous sheet, but because there's a formula in O, the formula in S and U think that cell O is not blank. Is there a workaround to this? Let me know if I need to explain myself more.
Cell Formulas | ||
---|---|---|
Range | Formula | |
O11 | O11 | =IF('DS (1)'!U11="OUT","18:30","") |
S11 | S11 | =IF((AND(ISBLANK(Q11),O11>0)),TEXT("01/02/1900 6:30"-O11,"h:mm")*24,TEXT((IF(Q11<O11,Q11+1,Q11)-O11),"h:mm")*24) |
U11 | U11 | =IF((AND(ISBLANK(Q11),O11>0)),"OUT","GTG") |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
U11,U14,U17,U20,U29,U38,U47,U56,U23,U32,U41,U50,U26,U35,U44,U53 | Cell Value | contains "G2G" | text | NO |
U11,U14,U17,U20,U29,U38,U47,U56,U23,U32,U41,U50,U26,U35,U44,U53 | Cell Value | contains "OUT" | text | NO |
U11,U14,U17,U20,U29,U38,U47,U56,U23,U32,U41,U50,U26,U35,U44,U53 | Cell Value | contains "Out" | text | NO |