I am building a spreadsheet to track the weekly standings in a league. I am hoping I can have boxes next to each division's standings that tracks which weeks (if any) are missing results. I was thinking to use conditional formatting to change the font color of future weeks to white (so they appear empty when I post the spreadsheet) however, I can't figure out how to make it work. I've attached the spreadsheet. On the 'standings' tab H3-S3 is where I will track the weeks for the team "THE*BOYS". If they have a score on the 'scores' tab for week 1 H3 will be blank. However, to avoid confusion I don't want weeks 2-12 to have anything until that week has past. I was thinking of adding the end date for each week somewhere to the right (so it won't print) to give excel something to compare 'today()' with, but I can't figure out how to make it work right.
Bookmarks