Conditional formatting with Rank
Hi there,
I have a column of data that changes regularly. I want to set up conditional
formatting whereby the top 5 datapoints show up in a different color to the
others. I think I have to use Rank for this but am not sure how?
Thanks!
|