Hi All,
The pic below is a calendar I've created for cycling events on throughout the year. I want to rows to be RED once they've finished, GREEN if they're this week and YELLOW if they're next week. I'm able to format the cells with the date in it but how do I apply this to the whole row? Thanks in advance for any help.
Shane
Excel Query.JPG
Bookmarks