I have a scoreboard program that updates a gymnasts position within a range to show their current position, after entering each score i.e.1st, 2nd or 3rd
Is there a way of highlighting the cell or the text colour so that it can be located more easily?
The formula used for updating the position is =IF(G3=0,"",RANK(G3,G$3:G$11))
assuming gymnasts in the rang g3 to g11 i.e. 9 gymnasts
all help most welcome