I have a big Excel file that I am using to collect data from multiple sources about some Events (let's call them Event1, Event2, Event3...). Since multiple sources can provide information about the same Event, for each source referring to the same Event I insert a new line and a new ID (the image below provides an example: I have multiple sources describing Event1, so I sort them using different IDs, i.e. 1.1, 1.2, ...)
To facilitate the visualization of these data, I would like to color the background of all the entries referring to the same Event with the same color, as shown in the image below. For example, all the lines whose first cell has the integer 1 should be grey, all those with the integer 2 should be pink and so on. However, I did not find any function or command to automatically do this. Is there a method to do this in Excel automatically?