nordlead said: lol, that isn't what I meant with the gray. I meant the NE/Buf and SD/Oak games Either way, great job. |
Spent some time trying to get the "unplayed" (rather than the "missed") games to be gray. The issue is that while I can have it format the cell based on what it is or isn't I can't format the cell based on what another cell is or isn't. In this case I would need to format each player's prediction cell based on what the "Actual" row says.
All of the formatting is done based on a comparison to the cell it is formatting...so I can ask "Is this cell equal to [that] sell?" and format based on the answer.
In short I could make the cells gray but it would require game by game formatting of every row rather than the existing automated formatting that I have set up right now. I've set the bottom row to have a conditional formatting so that unfunished games show up as gray in that row but thats probably the best I can do unless someone who knows more about OpenOffice spreadsheets than I do (and there aren't too many people like this) can show me how to do it.
edit: PS - I'm putting up the first MNF game update now and I will have the Week 2 ballot up shortly after since all submissions are now closed. The first MNF game update is done, week 2 ballot is up, and the scores are current as of the 2nd quarter of SD @ OAK. Last update of the night will be coming once the game is over.