I have a very large set of data. I need to automatically highlight identical sets of cells provided that each corresponding cell to the left is greater than a certain number.
For example, below if every asset test date for a given work order number is greater than 12/31/2018 then the entire 'set' of work order numbers gets highlighted, else none of them get highlighted.

So, for below the first row work order number 20409863 , NONE of the 20409863 cells get highlighted because just one test date doesn't meet the requirement.
20410401 gets highlighted because it's date is greater than 12/31/2018 and there's just one asset for this particular w/o number.
20410486 is same situation as the first example, so none of the cells with value 20410486 get highlighted.
26817574 - every adjacent cell next test date is greater than the requirement, so every cell value 26817574 will be highlighted (green color)

6/22/2017 20409863
1/19/2021 20409863
1/19/2021 20409863
1/11/2027 20410401
12/20/2025 20410486
2/5/2017 20410486
11/9/2020 20410486
5/7/2026 26817574
5/7/2026 26817574
12/7/2026 26817574