I read this before posting my question. I don't know how to write my formula, I've never worked with time formatted cells before in Excel and don't know where to start.
I'm working on a schedule in Excel 2003 that is supposed to highlight the event happening on a given time of the day, namely music competitions.
After the time is passed (time frames ranging from 10 to 30 min according to different sets of columns), the next range of cells underneath will...