Spreadsheet: 770943d1646341138-help-with-conditional-formatting-conditional-format-example
Sheet: Sheet1

Same thing | Shipment number | State | Other data | Date | QTY |  | List
Apples | 1 | NY | Farm | 2022-02-14 00:00:00 | 33 |  | Apples
Apples | 1 | PA | Farm | 2022-02-14 00:00:00 | 30 |  | Grapes
Pears | 1 | GA | Farm | 2022-02-14 00:00:00 | 33 |  | Pinapples
Pears | 1 | GA | Farm | 2022-02-14 00:00:00 | 27 |  | Bananas
Pears | 1 | GA | Farm | 2022-02-14 00:00:00 | 28 |  | Grapefruits
Pears | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Pears | 1 | GA | Farm | 2022-02-14 00:00:00 | 23
Pears | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Pears | 1 | GA | Farm | 2022-02-14 00:00:00 | 34
Pears | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Pears | 1 | GA | Farm | 2022-02-14 00:00:00 | 34
Apples | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Apples | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Apples | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Apples | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 30
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 27
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 32
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 24.5
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 36
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 30
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 32
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 27
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 35.5
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 30.5
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 34
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 34
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 28
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 25
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 31
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 26
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 30
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 29
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 30
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 32.5
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 28.5
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 31.5
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 36
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 34
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 27
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 34
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 30
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 27
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 30
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 34
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 24
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 30.5
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 34
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 36
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 34
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 36
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 32
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 30
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 32
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 26
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 27
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 27.5
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 30
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 28.5
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 27.5
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 28
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 28
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 35.5
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 34
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 25
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 30
Oranges | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 24.5
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 25
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 27.5
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 35.5
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 35
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-14 00:00:00 | 25
Bananas | 1 | GA | Farm | 2022-02-09 00:00:00 | 24.5
Bananas | 1 | GA | Farm | 2022-02-09 00:00:00 | 31
Bananas | 1 | GA | Farm | 2022-02-09 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-09 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-09 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-09 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-09 00:00:00 | 35
Bananas | 1 | GA | Farm | 2022-02-09 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-09 00:00:00 | 33
Bananas | 1 | GA | Farm | 2022-02-09 00:00:00 | 30
Bananas | 1 | GA | Farm | 2022-02-09 00:00:00 | 33
Kiwki | 1 | GA | Farm | 2022-02-09 00:00:00 | 30
[NAME] | 1 | GA | Farm | 2022-02-09 00:00:00 | 33
Grapes | 1 | GA | Farm | 2022-02-09 00:00:00 | 33
Grapes | 1 | GA | Farm | 2022-02-09 00:00:00 | 33
Grapes | 1 | GA | Farm | 2022-02-09 00:00:00 | 35
Grapes | 1 | GA | Farm | 2022-02-09 00:00:00 | 35