Conditional formatting as a function of rank or average (ideally I learn how to do both)

I have a spreadsheet that I want to conditional format by rank or as a scale of how above or below average they are, top 20% characters in each rank, top 40% etc. with 300 characters or so. Currently I only know how to do conditional formatting as a function of percentage of the highest value, picture included. Is there a way to instead to have it scale based on the rank (top 1 top 2, top 3...median...bottom 30 etc.) instead of the value itself? I need the cells themselves to show the value while the colours/arrows/whatever else to show the rank. 2025-02-02_13h46_18.pngAttachment 888925

Alternatively I want to set the average as the middle of the scale