Spreadsheet: 225041d1364870917-conditional-formatting-with-multiple-sheets-involved-status-color-formatting-sample-1-
Sheet: Main

 |  |  |  |  |  |  |  |  |  |  | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2013-01-31 00:00:00 | 2013-02-28 00:00:00 | 2013-03-31 00:00:00 | 2013-04-30 00:00:00 | 2013-05-31 00:00:00 | 2013-06-30 00:00:00 | 2012-07-31 00:00:00 | 2012-08-31 00:00:00 | 2012-09-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-30 00:00:00 | 2012-12-31 00:00:00
ITEM NAME |  |  |  |  |  |  |  |  |  |  | QUANTITY ON ORDER BY MONTH TO BE SHIPPED
 |  |  |  |  |  |  |  |  |  |  | JAN '13 | FEB '13 | MAR '13 | APR '13 | MAY '13 | JUN '13 | JUL '12 | AUG '12 | SEPT '12 | OCT '12 | NOV '12 | DEC '12
 |  |  |  |  |  |  |  |  |  |  |  |  | Have Fabric/Not Cut |  | Cut/Sewing |  | Sewn |  | Packed |  | Shipping |  | <---------------- hide if necessary--------------------------------------------------------->
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 3 |  | 4 |  | 5
AB02-A225-BLK-XS
AB03-A225-BLK-S
AB04-A225-BLK-M
AB05-A225-BLK-L
AB06-A225-BLK-XL
AB07-A225-BLK-2XL
AB08-A225-BLK-3XL
AB09-A225-BLK-4XL
AB10-A225-BLK-5XL
AB11-A225-BLK-6XL
AB01-A311-BLK-XXS
AB02-A311-BLK-XS
AB03-A311-BLK-S
AB04-A311-BLK-M
AB05-A311-BLK-L
AB06-A311-BLK-XL
AB07-A311-BLK-2XL
AB08-A311-BLK-3XL
AB09-A311-BLK-4XL
AB10-A311-BLK-5XL
AB11-A311-BLK-6XL
AB12-A311-BLK-7XL
AB13-A311-BLK-8XL
[NAME]
AB15-A311-BLK-10XL
ACA00-A225-CRB-XXXS
ACA01-A225-CRB-XXS
ACA02-A225-CRB-XS
ACA03-A225-CRB-S
ACA04-A225-CRB-M
ACA05-A225-CRB-L
ACA06-A225-CRB-XL
ACA07-A225-CRB-2XL
[NAME]-CRB-3XL
ACA09-A225-CRB-4XL
ACA10-A225-CRB-5XL
ACA11-A225-CRB-6XL
ACA00-A311-CRB-XXXS
ACA01-A311-CRB-XXS
[NAME]
ACA03-A311-CRB-S
[NAME]
ACA05-A311-CRB-L
ACA06-A311-CRB-XL
ACA07-A311-CRB-2XL
[NAME]-CRB-3XL
ACA09-A311-CRB-4XL
ACA10-A311-CRB-5XL
ACA11-A311-CRB-6XL
ACA12-A311-CRB-7XL
ACA13-A311-CRB-8XL
ACA14-A311-CRB-9XL
ACA15-A311-CRB-10XL
ACE00-A225-CEI-XXXS
ACE01-A225-CEI-XXS
ACE02-A225-CEI-XS
ACE03-A225-CEI-S
ACE04-A225-CEI-M
ACE05-A225-CEI-L
ACE06-A225-CEI-XL
ACE07-A225-CEI-2XL
ACE08-A225-CEI-3XL
ACE09-A225-CEI-4XL
ACE10-A225-CEI-5XL
ACE11-A225-CEI-6XL
ACE00-A311-CEI-XXXS
ACE01-A311-CEI-XXS
ACE02-A311-CEI-XS
ACE03-A311-CEI-S
ACE04-A311-CEI-M
ACE05-A311-CEI-L
ACE06-A311-CEI-XL
ACE07-A311-CEI-2XL
ACE08-A311-CEI-3XL
ACE09-A311-CEI-4XL
ACE10-A311-CEI-5XL
ACE11-A311-CEI-6XL
ACE12-A311-CEI-7XL
ACE13-A311-CEI-8XL
ACE14-A311-CEI-9XL
ACE15-A311-CEI-10XL
AG01-A225-GRP-XXS
AG02-A225-GRP-XS
AG03-A225-GRP-S
AG04-A225-GRP-M
AG05-A225-GRP-L
AG06-A225-GRP-XL
AG07-A225-GRP-2XL
AG08-A225-GRP-3XL
AG09-A225-GRP-4XL
AG10-A225-GRP-5XL
AG11-A225-GRP-6XL
AG12-A225-GRP-7XL
AG01-A311-GRP-XXS
AG02-A311-GRP-XS
AG03-A311-GRP-S
AG04-A311-GRP-M
AG05-A311-GRP-L
AG06-A311-GRP-XL
AG07-A311-GRP-2XL
AG08-A311-GRP-3XL
AG09-A311-GRP-4XL
AG10-A311-GRP-5XL
AG11-A311-GRP-6XL
AG12-A311-GRP-7XL
AG01-A100-GRP-XXS
AG02-A100-GRP-XS
AG03-A100-GRP-S
AG04-A100-GRP-M
AG05-A100-GRP-L
AG06-A100-GRP-XL
AG07-A100-GRP-2XL
AG08-A100-GRP-3XL
AG09-A100-GRP-4XL
AG10-A100-GRP-5XL
AG11-A100-GRP-6XL
AG12-A100-GRP-7XL
AG13-A100-GRP-8XL
[NAME]
[NAME]-GRP-10XL
AG01-A300-GRP-XXS
AG02-A300-GRP-XS
AG03-A300-GRP-S
AG04-A300-GRP-M
AG05-A300-GRP-L
AG06-A300-GRP-XL
AG07-A300-GRP-2XL
AG08-A300-GRP-3XL
AG09-A300-GRP-4XL
AG10-A300-GRP-5XL
AG11-A300-GRP-6XL
AG12-A300-GRP-7XL
AG13-A300-GRP-8XL
[NAME]
[NAME]
AK01-A225-KHA-XXS
AK02-A225-KHA-XS
AK03-A225-KHA-S
AK04-A225-KHA-M
AK05-A225-KHA-L
AK06-A225-KHA-XL
AK07-A225-KHA-2XL
AK08-A225-KHA-3XL
AK09-A225-KHA-4XL
AK10-A225-KHA-5XL
AK11-A225-KHA-6XL
AK01-A311-KHA-XXS
AK02-A311-KHA-XS
[NAME]
AK04-A311-KHA-M
AK05-A311-KHA-L
AK06-A311-KHA-XL
AK07-A311-KHA-2XL
AK08-A311-KHA-3XL
AK09-A311-KHA-4XL
AK10-A311-KHA-5XL
AK11-A311-KHA-6XL
AK12-A311-KHA-7XL
AK01-A100-KHA-XXS
AK02-A100-KHA-XS
AK03-A100-KHA-S
AK04-A100-KHA-M
AK05-A100-KHA-L
AK06-A100-KHA-XL
AK07-A100-KHA-2XL
AK08-A100-KHA-3XL
AK09-A100-KHA-4XL
AK10-A100-KHA-5XL
AK11-A100-KHA-6XL
AK12-A100-KHA-7XL
AK13-A100-KHA-8XL
AK14-A100-KHA-9XL
AK15-A100-KHA-10XL
AN00-A225-NVY-XXXS
AN01-A225-NVY-XXS
AN02-A225-NVY-XS
AN03-A225-NVY-S
AN04-A225-NVY-M
AN05-A225-NVY-L
AN06-A225-NVY-XL
AN07-A225-NVY-2XL
AN08-A225-NVY-3XL
[NAME]
AN10-A225-NVY-5XL
AN11-A225-NVY-6XL
AN00-A311-NVY-XXXS
AN01-A311-NVY-XXS
AN02-A311-NVY-XS
AN03-A311-NVY-S
AN04-A311-NVY-M
AN05-A311-NVY-L
AN06-A311-NVY-XL
AN07-A311-NVY-2XL
AN08-A311-NVY-3XL
[NAME]
AN10-A311-NVY-5XL
AN11-A311-NVY-6XL
AN12-A311-NVY-7XL
AN13-A311-NVY-8XL
AN14-A311-NVY-9XL
AN15-A311-NVY-10XL