Spreadsheet: 132499d1323792265-excel-2007-conditional-formatting-format-multiple-rows-based-on-same-criteria-sample-grading-1
Sheet: List1

 |  |  |  | Company A | Company B | Company C | Company D
# | Product | Quantity | Unit | Price/Unit | Price/Unit | Price/Unit | Price/Unit
1. |  | 3600 | [NAME] | 1.759 | 1.79205 | 1.651 | 1.6944
2. |  | 750 | [NAME] | 1.3255 | 1.0001085 | 1.1085 | 1.1085
3. |  | 600 | [NAME] | 1.3255 | 1.1953 | 1.1628 | 1.1736
4. |  | 210 | [NAME] | 1.9765 | 2.29115 | 2.2152 | 2.1393
5. |  | 1200 | [NAME] | 2.4105 | 2.57325 | 2.736 | 2.302
6. |  | 300 | [NAME] | 2.4105 | 2.57325 | 3.1592 | 2.3563
7. |  | 300 | [NAME] | 2.4105 | 2.57325 | 3.1592 | 2.6818
8. |  | 2700 | [NAME] | 1.7595 | 1.64015 | 1.651 | 1.5968
9. |  | 180 | [NAME] | 1.651 | 1.0001085 | 1.1085 | 1.9765
10. |  | 270 | [NAME] | 1.5425 | 1.7378 | 1.6944 | 1.6727
11. |  | 1500 | [NAME] | 1.651 | 1.64015 | 1.651 | 1.6402
12. |  | 189 | [NAME] | 1.3798 | 1.3689 | 1.3255 | 1.2713
13. |  | 1800 | [NAME] | 1.1411 | 1.16275 | 1.1411 | 1.1519
14. |  | 2400 | [NAME] | 1.651 | 1.57505 | 1.3472 | 1.4557
15. |  | 360 | [NAME] | 1.3255 | 1.0001085 | 1.0543 | 1.1519
16. |  | 150 | [NAME] | 1.868 | 2.29115 | 2.1935 | 1.868
17. |  | 120 | [NAME] | 1.651 | 1.70525 | 1.7053 | 1.651
18. |  | 2100 | [NAME] | 1.1411 | 1.0001085 | 1.0543 | 1.1085
19. |  | 600 | [NAME] | 1.651 | 2.0633 | 1.7595 | 1.6836
20. |  | 900 | [NAME] | 1.3255 | 1.0001085 | 1.1085 | 1.1085
21. |  | 450 | [NAME] | 1.7595 | 1.0001085 | 2.1935 | 1.8138
22. |  | 450 | [NAME] | 1.7595 | 1.7378 | 1.8355 | 2.0308
23. |  | 1050 | [NAME] | 1.868 | 1.53165 | 1.8355 | 1.8138
24. |  | 1200 | [NAME] | 1.651 | 1.70525 | 1.5968 | 1.5642
25. |  | 120 | [NAME] | 1.5425 | 2.13925 | 1.868 | 1.8138
26. |  | 150 | [NAME] | 1.4883 | 1.8897 | 1.651 | 1.5968
27. |  | 600 | [NAME] | 1.7595 | 1.0001085 | 1.1085 | 1.5425
28. |  | 2300 | [NAME] | 1.868 | 1.434 | 1.868 | 1.3255
29. |  | 600 | [NAME] | 1.7595 | 2.03075 | 2.085 | 2.1393
30. |  | 2100 | [NAME] | 1.70525 | 1.72695 | 1.6293 | 1.5968
31. |  | 600 | [NAME] | 1.92225 | 2.50815 | 2.1935 | 2.1393
32. |  | 300 | [NAME] | 1.92225 | 2.50815 | 1.651 | 1.7595
33. |  | 300 | [NAME] | 1.92225 | 2.03075 | 1.9548 | 1.8138
34. |  | 300 | [NAME] | 2.1935 | 2.35625 | 2.085 | 1.9223
35. |  | 60 | [NAME] | 2.953 | 3.7125 | 3.4955 | 3.0507
36. |  | 300 | [NAME] | 1.16275 | 1.217 | 1.1628 | 1.1628
37. |  | 300 | [NAME] | 1.217 | 1.0001085 | 1.0543 | 1.1411
38. |  | 300 | [NAME] | 1.70525 | 1.59675 | 1.5208 | 1.5968
39. |  | 60 | [NAME] | 1.434 | 1.4774 | 1.3255 | 1.217
 |  |  |  | Company A | Company B | Company C | Company D
# | Product | Quantity | Unit | Price/Unit | Price/Unit | Price/Unit | Price/Unit
1. |  | 270 | [NAME] | 1.651 | 2.0308 | 1.48825 | 1.5642
2. |  | 180 | [NAME] | 1.8138 | 2.3563 | 1.7595 | 1.5642
 |  |  |  | Company A | Company B | Company C | Company D
# | Product | Quantity | Unit | Price/Unit | Price/Unit | Price/Unit | Price/Unit
1. |  | 3780 | pcs | 1.5425 | 1.2604 | 1.7053 | 1.868
2. |  | 2580 | pcs | 1.3147 | 1.2387 | 1.651 | 1.9223
 |  |  |  | Company A | Company B | Company C | Company D
# | Product | Quantity | Unit | Price/Unit | Price/Unit | Price/Unit | Price/Unit
1. |  | 627 | pcs | 6.6261 | 7.7487 | 6.3708 | 11.3075
2. |  | 630 | pcs | 7.214 | 7.9983 | 6.3708 | 11.3075
3. |  | 630 | pcs | 6.8095 | 8.0525 | 6.3708 | 11.85
4. |  | 627 | pcs | 6.5037 | 7.7107 | 6.3708 | 11.85
5. |  | 630 | pcs | 6.6261 | 7.8355 | 6.3708 | 11.85
 |  |  |  | Company A | Company B | Company C | Company D
# | Product | Quantity | Unit | Price/Unit | Price/Unit | Price/Unit | Price/Unit
1. |  | 135 | pcs | 5.1773 | 8.0525 | 5.7198 | 8.594999999999999
 |  |  |  | Company A | Company B | Company C | Company D
# | Product | Quantity | Unit | Price/Unit | Price/Unit | Price/Unit | Price/Unit
1. |  | 10800 | pcs | 1.13 | 1.1302 | 1.089 | 1.1063