Anyone know how to write a VBA to do a pattern search of a spreadsheet where Conditional Formatting has highlighting a cell to a certain color (green for this example)?

My spreadsheet has 200,000 rows with data points and I would like to know if any of the data patterns repeat themselves(ie A1:AN1, the highlighted pattern of cells A1,D1,I1,O1,U1,AH1)? I've included a sample of my spreadsheet. Some of my data points have a higher value then 1, but I've just used 1 in the example to make it easier. Thanks

DataLog.xls