Hello Excel Wizards,
I am looking how to set up my excel so that I can put a number into Hitting/Pitching/Fielding/Popfly's/Running but shows up as stars and then gives me the rating. I know I can do numbers but stars (or even half stars) would be pretty cool.
It would need to work on my phone as I will need to input the number in the correct cell pretty quickly.
Any help would be appreciated!
I am looking how to set up my excel so that I can put a number into Hitting/Pitching/Fielding/Popfly's/Running but shows up as stars and then gives me the rating. I know I can do numbers but stars (or even half stars) would be pretty cool.
It would need to work on my phone as I will need to input the number in the correct cell pretty quickly.
Any help would be appreciated!
Group | Number | Player Name | Hitting | Pitching | Fielding | Popflys | Running | Rating |
1 | 1 | Steven | 2.5 | 3 | 4 | 5 | 1 | 3.1 |
1 | 2 | John | 2 | 3.5 | 4 | 5 | 1 | 3.1 |
1 | 3 | Bill | 2 | 3 | 4.5 | 5 | 1 | 3.1 |
1 | 4 | Joe | 2 | 3 | 4 | 5 | 1 | 3 |
1 | 5 | Evan | 2 | 3 | 4 | 1.5 | 1 | 2.3 |
2 | 6 | Houston | 2 | 3 | 2 | 5 | 1 | 2.6 |
2 | 7 | Cameron | 2 | 3 | 4 | 5 | 1 | 3 |
2 | 8 | Mike | 2 | 3 | 4 | 5 | 1 | 3 |
2 | 9 | Brady | 2 | 3 | 4 | 5 | 1 | 3 |
2 | 10 | Parker | 2 | 3 | 4 | 5 | 1 | 3 |