Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie: laura84
| Femeie 24 ani Valcea cauta Barbat 24 - 49 ani |
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 772
|
|
If you want to color Top 3 values in different color each, eg.: - highest value - green - 2nd highest value - yellow - 3rd highest value - red
1. Select desired range.
2. Make one conditional formatting rule for Top 3 and color it in red. All three highest values should be red.
3. Make another conditional formatting rule for Top 2 and color it in yellow. The two highest values should be yellow and the 3rd should be red.
4. Make a 3rd conditional formatting rule for Top 1 and color it in green. The highest value is now green, 2nd is yellow and 3rd is red.
It's all about the order of the rules.
|
|
pus acum 3 ani |
|