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 is what I've done. The first set is working, but the copied second doesn't

Here's a link to it as well https://docs.google.com/spreadsheets/d/1kIYfF2cCDfWTYVebFsXxveh2f9GoOjydAG2XOiFw2v0/edit?usp=sharing

  • Russell, this can be done with some very complex conditional formatting. I would not be able to explain it well here. If you'd like to change your sheet link to "Anyone with the link can edit," I'd be happy to implement the CF after which you can study it if you like. – Erik Tyler 13 hours ago
  • I've made it so that anyone can edit. Thank you for the help. – Russell 13 mins ago

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.