I've set up conditional formatting to highlight the top 3 values (gold, silver, bronze) in a range of rows. However, I want to be able to copy/paste the conditional formatting below the initial rows for multiple datasets and have the conditional formatting function on each individually.
Currently, I have it working in the initial dataset, but it breaks when copying more below it. My conditional formatting is currently (with two additional formats for silver and bronze)
I've tried pretty much every variation in absolutes and relatives, as well as using RANK without success.
Here's a link to it as well https://docs.google.com/spreadsheets/d/1kIYfF2cCDfWTYVebFsXxveh2f9GoOjydAG2XOiFw2v0/edit?usp=sharing