I really liked your idea, but I thought it would be better if each of the three largest values had a different color. It was only necessary to create three rules: the same formula changing only the "k" to 1 (largest value), 2 (2nd largest value) and 3 (3rd largest value). Then, format it, giving each value a different color. 🤗
That's ok. A very useful tutorial. Thank you, Alan.
Cheers, Ivan.
Marvelous 👍👍👍
Thank you!
Pretty simple solution but the creativity is what add a lot of value here! thanks for sharing this tip!!
You're welcome 😊
Another excel trick....thank you sir
You are bliss to all of us
Thank you, Naveen
I really liked your idea, but I thought it would be better if each of the three largest values had a different color.
It was only necessary to create three rules: the same formula changing only the "k" to 1 (largest value), 2 (2nd largest value) and 3 (3rd largest value).
Then, format it, giving each value a different color. 🤗
Nice ! 👍