Spreadsheet: 883135d1731614511-conditional-formatting-based-on-two-ranges-excel-help
Sheet: GMM CAN List

 |  |  |  |  |  |  |  | Reconciled |  |  | Place
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | P
 |  |  |  |  |  |  |  | N |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | P
 |  |  |  |  |  |  |  | N |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | Y |  |  | P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P
 |  |  |  |  |  |  |  | N |  |  | Not P