Hi all,

I have a spreadsheet with multiple time stamped entries for people. These people can clock in or out in several places at the same time. trying to write a formula or macro (not sure which achieves the aim best in this case) that will search the data and highlight in red lines with times that over lap for a specific person. Is this possible? and is it something somebody could help with please? i've copied a few lines below as an example. many thanks

excel queston.jpg