Spreadsheet: 50966d1250565111-how-to-apply-conditional-formatting-rule-to-all-rows-in-spreadsheet-excel_forum
Sheet: Comparison

Order Number | Total Weight (kg) | Post codes | TNT | [NAME] | Bluestar | R&S | Allied  Express | Territory | NQX
 | 59.40000000000001 | 5118 |  |  |  | - |  | SA
 | 36.036 | 5118 |  |  |  | - |  | SA
 | 354.8820000000001 | 6018 |  |  |  |  |  | WA
 | 209.319 | 7310 |  |  |  | - |  | TAS
 | 106.623 | 6450 |  |  |  |  |  | WA
 | 266.7324 | 4405 |  |  |  | - |  | QLD
 | 26.43432 | 4825 |  |  |  | - |  | Mount Isa
 | 25 | 2000 |  |  |  | - |  | NW
 | 50 | 2000 |  |  |  | - |  | NW
 | 100 | 2000 |  |  |  | - |  | NW
 | 200 | 2000 |  |  |  | - |  | NW
 | 300 | 2000 |  |  |  | - |  | NW
 | 25 | 2600 |  |  |  | - |  | NW | -
 | 50 | 2600 |  |  |  | - |  | NW | -
 | 100 | 2600 |  |  |  | - |  | NW | -
 | 200 | 2600 |  |  |  | - |  | NW | -
 | 300 | 2600 |  |  |  | - |  | NW | -
 | 25 | 4000 |  |  |  | - |  | QLZ
 | 50 | 4000 |  |  |  | - |  | QLZ
 | 100 | 4000 |  |  |  | - |  | QLZ
 | 200 | 4000 |  |  |  | - |  | QLZ
 | 300 | 4000 |  |  |  | - |  | QLZ
 | 25 | 5000 |  |  |  | - |  | SA
 | 50 | 5000 |  |  |  | - |  | SA
 | 100 | 5000 |  |  |  | - |  | SA
 | 200 | 5000 |  |  |  | - |  | SA
 | 300 | 5000 |  |  |  | - |  | SA
 | 25 | 6000 |  |  |  |  |  | WA | -
 | 50 | 6000 |  |  |  |  |  | WA | -
 | 100 | 6000 |  |  |  |  |  | WA | -
 | 200 | 6000 |  |  |  |  |  | WA | -
 | 300 | 6000 |  |  |  |  |  | WA | -
 | 25 | 7000 |  |  |  | - |  | TAS | -
 | 50 | 7000 |  |  |  | - |  | TAS | -
 | 100 | 7000 |  |  |  | - |  | TAS | -
 | 200 | 7000 |  |  |  | - |  | TAS | -
 | 300 | 7000 |  |  |  | - |  | TAS | -
8925A | 4 | 4030 |  | 9 | 13.25 | - | 9 | Brisbane | 80
8990 | 25 | 7009 |  | 10.96 |  | - |  |  | 80
8991 | 19 | 4122 |  | 14.89 |  | - |  | Brisbane | 80
8989 | 43 | 2251 |  | 25.92 |  | - |  |  | 80
8987 | 132 | 2085 |  | 39.34 |  | - |  | Sydney | 80
8986 | 52 | 4567 |  | 39.24 |  | - |  | Sunshine Coast | 80
8992 | 25 | 3147 |  | 2.63 | 13.25 | - |  |  | 80
8999 | 110 | 4825 |  | 160.6 |  | - |  | Mount Isa | 80
9001 | 43 | 2154 |  | 17.54 |  | - |  | Sydney | 80
8994 | 283 | 2067 |  | 76.34 |  | - |  | Sydney | 80
8997 | 14 | 4878 |  | 20.65 |  | - |  |  | 80
8995 | 50 | 3220 |  | 8.780000000000001 |  | - |  |  | 80
9002 | 32 | 4807 |  | 43.28 |  | - |  | Townsville | 80
8998 | 19 | 5271 |  | 18.19 |  | - |  |  | 80
8993 | 4 | 5267 | 13 | 10.46 | 15.63 | - |  |  | 80
8988 | 200 | 3930 |  | 35.12 |  | - |  |  | 80
9000 | 125 | 3206 |  | 13.15 |  | - |  |  | 80
8996 | 25 | 3500 |  | 6.149999999999999 |  | - |  |  | 80
8783 | 31 | 2866 |  | 25.3 |  | - |  |  | 80
9003 | 25 | 3013 |  | 2.63 | 13.25 | - |  |  | 80
9007 | 31 | 4218 |  | 26.22 |  | - |  | Gold Coast | 80
9005 | 75 | 3148 |  | 7.89 |  | - |  |  | 80
9006 | 63 | 6162 |  | 49.53 |  |  |  | WA | 80
9008 | 200 | 3192 |  | 21.04 |  | - | 9 |  | 80
9004 | 18 | 4405 |  | 20.55 |  | - |  |  | 80
9011 | 3 | 2093 |  | 9 | 13.25 | - | 9 | Sydney | 80
9010 | 81 | 2289 |  | 42.64 |  | - |  | Newcastle | 80
9009 | 300 | 3150 |  | 31.56 |  | - |  |  | 80
9012 | 62 | 2022 |  | 22.19 |  | - |  | Sydney | 80
9013 | 50 | 5068 |  | 19.25 |  | - |  |  | 80
6 | 35 | 6154 |  | 30.63 |  |  |  | WA | 80
1 | 38 | 5094 |  | 16.31 |  | - |  |  | 80
4 | 150 | 3058 |  | 15.78 |  | - | 9 |  | 80
7 | 3 | 2600 |  | 9 | 15.63 | - | 12.15 |  | 80
2 | 14 | 2360 |  | 16.03 |  | - |  |  | 80
9015 | 29 | 2000 |  | 14.11 |  | - |  | Sydney | 80
5 | 111 | 2022 |  | 34.2 |  | - |  | Sydney | 80
8 | 50 | 3280 |  | 12.3 |  | - |  |  | 80
3 | 16 | 5067 |  | 10.92 | 13.25 | - |  |  | 80
VL | 56 | 3058 |  | 8.629999999999999 |  | - |  |  | 80
9021 | 50 | 3000 |  | 5.26 |  | - |  |  | 80
9018 | 75 | 3860 |  | 18.45 |  | - |  |  | 80