Hi trying to find a way to check cells where the code in the first column is the same, it finds the highest number in the group, highlights this green the then finds items around it that are different from green values and highlights in red as per attached screen shot....
Not sure how to achieve this?
Capture.PNG
Bookmarks