Hi, I have watched videos and tried Conditional Formatting, Macro and Active cell editing, but still can't seem to find answers or any Etsy shop that has an electronic spreadsheet. I am sure this is simple, but need some help.
I have a basic spreadsheet with rows and columns.
So, for example, Row 1 would be labeled Round 3..and each column is the players name, so for 4 players, Row 1 could have 10, 13, 0, 20 (which would indicate the players score) and the score card would have 13 Rounds. BUT, the Round also indicates what Round the players are on. What I want to do is, once I complete the last score for the 4th Player, for the next ROW to highlight. In my attached example, it would be ideal for Row 4 to highlight (within table area, not entire row), I was able to create button that would clear contents and to sum score totals, but not the highlight "round" row.
Any suggestions or help would be greatly appreciated.
Thanks in advance.
I have a basic spreadsheet with rows and columns.
So, for example, Row 1 would be labeled Round 3..and each column is the players name, so for 4 players, Row 1 could have 10, 13, 0, 20 (which would indicate the players score) and the score card would have 13 Rounds. BUT, the Round also indicates what Round the players are on. What I want to do is, once I complete the last score for the 4th Player, for the next ROW to highlight. In my attached example, it would be ideal for Row 4 to highlight (within table area, not entire row), I was able to create button that would clear contents and to sum score totals, but not the highlight "round" row.
Any suggestions or help would be greatly appreciated.
Thanks in advance.
