Hi all,
I have list of scores and positions. The "Scores" in Column A are sorted out into "Positions" in Column B
I would now like to highlight Positions 1,2,3,4 and 5 with a colour like yellow.
Scores are sorted by the formula =IF(A3=0;"";COUNTIFS($A$3:$A$17;">0";$A$3:$A$17;"<"&A3)+1)
Thx in advance
Bookmarks