Spreadsheet: 148299d1333338122-conditional-formatting-window-basic-question-kyler_spreadsheet
Sheet: Timeline

 |  | Fiscal Quarter | Q4 2012
 |  | Calendar Month | J | A | S | O | N | D | J | F | M | A | M | J | J | A | S | O | N | D | J | F | M | A | M | J
 | 9 | AND(VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)>=VLOOKUP('Product Design'!$D$9,'Product Design'!$E$54:$H$70,2,FALSE),VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)<=VLOOKUP('Product Design'!$E$9,'Product Design'!$E$54:$H$70,2,FALSE))
 | 10 | AND(VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)>=VLOOKUP('Product Design'!$D$10,'Product Design'!$E$54:$H$70,2,FALSE),VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)<=VLOOKUP('Product Design'!$E$10,'Product Design'!$E$54:$H$70,2,FALSE))
 | 11 | AND(VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)>=VLOOKUP('Product Design'!$D$11,'Product Design'!$E$54:$H$70,2,FALSE),VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)<=VLOOKUP('Product Design'!$E$11,'Product Design'!$E$54:$H$70,2,FALSE))
 | 12 | AND(VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)>=VLOOKUP('Product Design'!$D$12,'Product Design'!$E$54:$H$70,2,FALSE),VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)<=VLOOKUP('Product Design'!$E$12,'Product Design'!$E$54:$H$70,2,FALSE))
 | 13 | AND(VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)>=VLOOKUP('Product Design'!$D$13,'Product Design'!$E$54:$H$70,2,FALSE),VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)<=VLOOKUP('Product Design'!$E$13,'Product Design'!$E$54:$H$70,2,FALSE))
 | 14 | AND(VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)>=VLOOKUP('Product Design'!$D$14,'Product Design'!$E$54:$H$70,2,FALSE),VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)<=VLOOKUP('Product Design'!$E$14,'Product Design'!$E$54:$H$70,2,FALSE))
 | 15 | AND(VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)>=VLOOKUP('Product Design'!$D$15,'Product Design'!$E$54:$H$70,2,FALSE),VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)<=VLOOKUP('Product Design'!$E$15,'Product Design'!$E$54:$H$70,2,FALSE))
 | 16 | AND(VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)>=VLOOKUP('Product Design'!$D$16,'Product Design'!$E$54:$H$70,2,FALSE),VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)<=VLOOKUP('Product Design'!$E$16,'Product Design'!$E$54:$H$70,2,FALSE))
 | 17 | AND(VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)>=VLOOKUP('Product Design'!$D$17,'Product Design'!$E$54:$H$70,2,FALSE),VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)<=VLOOKUP('Product Design'!$E$17,'Product Design'!$E$54:$H$70,2,FALSE))
 | 18 | AND(VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)>=VLOOKUP('Product Design'!$D$18,'Product Design'!$E$54:$H$70,2,FALSE),VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)<=VLOOKUP('Product Design'!$E$18,'Product Design'!$E$54:$H$70,2,FALSE))
 | 19 | AND(VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)>=VLOOKUP('Product Design'!$D$19,'Product Design'!$E$54:$H$70,2,FALSE),VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)<=VLOOKUP('Product Design'!$E$19,'Product Design'!$E$54:$H$70,2,FALSE))
 | 20 | AND(VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)>=VLOOKUP('Product Design'!$D$20,'Product Design'!$E$54:$H$70,2,FALSE),VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)<=VLOOKUP('Product Design'!$E$20,'Product Design'!$E$54:$H$70,2,FALSE))
 | 21 | AND(VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)>=VLOOKUP('Product Design'!$D$21,'Product Design'!$E$54:$H$70,2,FALSE),VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)<=VLOOKUP('Product Design'!$E$21,'Product Design'!$E$54:$H$70,2,FALSE))
 | 22 | AND(VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)>=VLOOKUP('Product Design'!$D$22,'Product Design'!$E$54:$H$70,2,FALSE),VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)<=VLOOKUP('Product Design'!$E$22,'Product Design'!$E$54:$H$70,2,FALSE))
 | 23 | AND(VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)>=VLOOKUP('Product Design'!$D$23,'Product Design'!$E$54:$H$70,2,FALSE),VLOOKUP($g$6,'Product Design'!$E$54:$H$70,2,FALSE)<=VLOOKUP('Product Design'!$E$23,'Product Design'!$E$54:$H$70,2,FALSE))
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ND(VLOOKUP($D$6,'Product Design'!$E$27:$H$32,2,FALSE+$H$10OOKUP('Product Design'!$E$9,'Product Design'!$E$27:$H$32,2,FALSE),VLOOKUP($D$6,'Product Design'!$E$27:$H$32,2,FALSE)<=VLOOKUP('Product Design'!$F$9,'Product Design'!$E$27:$H$32,2,FALSE))