Refering to this thread

I want to highlight the 20 most recent scores blue and highlight the 10 lowest scores of that 20 scores red.

I did play around with the conditioning, but could not make it work.

Thanks in advance

Also: taking the formula in linked thread, i want to to calculate the player's handicap, his 13 most recent scores are taken, of which the 6 lowest scores are added together, multiplied by 0.96, divided by 6.

I did try
=INT((0.96*SUMPRODUCT(SMALL(INDEX($A$1:$A$100,LARGE(INDEX(ISNUMBER($A$1:$A$100)*ROW($A$1:$A$100),0),MIN(13,COUNT($A$1:$A$100)))):$A$100,ROW($1:$6))))/6)

but it don't work.