Spreadsheet: 80899d1281040973-conditional-formatting-using-multiple-criteria-on-the-right-track
Sheet: .xls)FY 2010

 | Associates |  | Feb. | Mar. | Apr. | May | Jun. | Jul. | Aug. | Sep. | Oct. | Nov. | Dec. | Jan. |  | TOTAL 2010
 | MONTH GOAL |  | 64 | 100 | 68 | 66 | 76 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 374
 | Full Time Goal |  | 4 | 5 | 4 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 21
* | Altherr | Sean | 2 | 0 | 1 | 1 | 0 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 4 |  | Altherr | Sean
 | Ayling | [NAME] | 1 | 2 | 4 | 1 | 1 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 9 |  | Ayling | [NAME]
 | [NAME] | Betty | 1 | 0 | 2 | 3 | 1 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 7 |  | [NAME] | Betty
 | Buntain | Anna | 2 | 4 | 5 | 15 | 8 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 34 |  | Buntain | Anna
 | [NAME] | [NAME] | 1 | 1 | 2 | 1 | 0 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 5 |  | [NAME] | [NAME]
* | [NAME] | Barb | 0 | 0 | 0 | 1 | 0 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 1 |  | [NAME] | Barb
 | Pingle | [NAME] | 0 | 0 | 0 | 2 | 1 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 3 |  | Pingle | [NAME]
 | [NAME] | [NAME] | 6 | 4 | 7 | 3 | 5 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 25 |  | [NAME] | [NAME]
 | [NAME] | Nikki | 3 | 1 | 6 | 12 | 7 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 29 |  | [NAME] | Nikki
 | Simpson | Kaitlin | 0 | 6 | 1 | 3 | 1 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 11 |  | Simpson | Kaitlin
 | Waclzak | [NAME] | 1 | 2 | 3 | 2 | 3 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 11 |  | Waclzak | [NAME]
* | Wilkins | [NAME] | 0 | 0 | 0 | 0 | 0 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 0 |  | Wilkins | [NAME]
 | Total |  | 17 | 20 | 31 | 44 | 27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 139
 | Part Time Goal |  | 3 | 4 | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 16
 | [NAME] | [NAME] | 4 | 14 | 8 | 7 | 16 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 49 |  | [NAME] | [NAME]
* | Hower | [NAME] | 1 | 4 | 4 | 2 | 0 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 11 |  | Hower | [NAME]
 | [NAME] | Brittany | 0 | 0 | 1 | 1 | 0 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 2 |  | [NAME] | Brittany
 | Newlove | Sandy | 2 | 3 | 2 | 2 | 1 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 10 |  | Newlove | Sandy
 | Pierson | [NAME] | 0 | 0 | 1 | 1 | 0 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 2 |  | Pierson | [NAME]
 | Total |  | 7 | 21 | 16 | 13 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 74
 | Short Hour [NAME] |  | 2 | 3 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 11
 | Beebee | [NAME] | 8 | 2 | 2 | 4 | 3 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 19 |  | Beebee | [NAME]
 | [NAME] | [NAME] | 2 | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 2 |  | [NAME] | [NAME]
* | Busdecker | [NAME] | 0 | 0 | 1 | 1 | 1 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 3 |  | Busdecker | [NAME]
* | Chapman | [NAME] | --------- | --------- | --------- | 0 | 2 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 2 |  | Chapman | [NAME]
 | Dorman | Amanda | 7 | 11 | 3 | 9 | 7 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 37 |  | Dorman | Amanda
 | Echleberry | Kelly | 2 | 0 | 2 | 2 | 3 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 9 |  | Echleberry | Kelly
* | Firsdon | Jessica | 0 | 1 | 0 | 0 | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 1 |  | Firsdon | Jessica
 | Fought | Michelle | 1 | 0 | 0 | 2 | 2 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 5 |  | Fought | Michelle
 | Heldman | Amber | 0 | 3 | 2 | 2 | 5 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 12 |  | Heldman | Amber
 | [NAME] | [NAME] | 0 | 3 | 1 | 2 | 4 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 10 |  | [NAME] | [NAME]
 | [NAME] | [NAME] | 2 | 0 | 2 | 0 | 0 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 4 |  | [NAME] | [NAME]
 | Klein | [NAME] | 2 | 1 | 0 | 4 | 1 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 8 |  | Klein | [NAME]
 | Kukwa | [NAME] | 2 | 2 | 1 | 1 | 0 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 6 |  | Kukwa | [NAME]
 | [NAME] | [NAME] | 4 | 4 | 2 | 3 | 4 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 17 |  | [NAME] | [NAME]
* | Lieb | Crystal | 0 | 0 | 0 | 1 | 1 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 2 |  | Lieb | Crystal
 | Loomis | Lauren | 8 | 16 | 1 | 4 | 7 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 36 |  | Loomis | Lauren
 | [NAME] | [NAME] | 0 | 1 | 2 | 1 | 3 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 7 |  | [NAME] | [NAME]
* | Romaker | [NAME] | 0 | 0 | 0 | 0 | 0 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 0 |  | Romaker | [NAME]
 | Schalk | [NAME] | 0 | 2 | 2 | 0 | 2 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 6 |  | Schalk | [NAME]
 | Smith | Tamara | 2 | 1 | 2 | 2 | --------- | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 7 |  | Smith | Tamara
 | West | [NAME] | 1 | 1 | 6 | 4 | 4 | --------- | --------- | --------- | --------- | --------- | --------- | --------- |  | 16 |  | West | [NAME]
 | Total |  | 41 | 48 | 29 | 42 | 49 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 209
 | MONTH ACTUAL |  | 65 | 89 | 76 | 99 | 93 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 422
 | Zero Performers |  | 14 | 13 | 8 | 6 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
 | # Met goal |  | 12 | 8 | 16 | 14 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10
 | # [NAME] |  | 23 | 23 | 28 | 31 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 36
 | % Met goal |  | 0.3243243243243243 | 0.2222222222222222 | 0.4444444444444444 | 0.3783783783783784 | 0.4571428571428571 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0.2631578947368421
 | % participated |  | 0.6216216216216216 | 0.6388888888888888 | 0.7777777777777778 | 0.8378378378378378 | 0.7142857142857143 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0.9473684210526315