Hi All,
The pic below is what I'm working with. I've created a calendar of cycling events occurring throughout the year. I want to highlight in RED what's finished, GREEN what's occurring this week and YELLOW what's happening next week. I've been able to conditionally format the cells with the date in them but how do I apply this to the entire row? Thanks in advance for your help.
Shane
Excel Query.JPG
Bookmarks