Hey everyone, I have a weird automatically created excel that I need to do some conditional formating on.

Basically, there are different locations that need to respond to us 3 times a day at 4 10 and 6. The excel contains the facility name and the time and date of response. Now, what I'm trying to do is format this so that if there are more or less than 3 responses per day, I want to highlight that group of rows. I have no idea how I can possibly do this programmaticly.

Any ideas guys?