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 highlight while the one that is over goes back to it's original color... And so on until the end of the day.
Is it possible to do so without having to revert to VB, which is like Chinese to me.
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 highlight while the one that is over goes back to it's original color... And so on until the end of the day.
Is it possible to do so without having to revert to VB, which is like Chinese to me.