Data Analyst

We have an on-line zoom enabled map with around 3,500 points of interest marked with a waypoint (pin) that shows a tile descriptor when a cursor is placed over it. The waypoint indicators are one of 3 colours (Red, Green, Grey) We also have an excel spread sheet with a similar index of the title descriptors of the waypoints that we need to catalogue to correspond with colour of the waypoints on the map The outcome we need is as follows:- Each title descriptor on the Excel spreadsheet is shaded the corresponding colour of the waypoint on the map Eg If the map waypoint is coloured red then the corresponding waypoint title cell on the excel sheet is red If the map waypoint is coloured green then the corresponding waypoint title is green etc We would also need an exception report to detail any waypoints or title descriptors that had no matching reference between the 2 source documents ie there is a pin but no title on the spreadsheet that matches