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:
Cezi la Simpatie.ro
 | Femeie
21 ani
Vaslui
cauta Barbat
23 - 80 ani |
|
TonyTzu
Moderator
 Inregistrat: acum 13 ani
Postari: 252
|
|
Source:
Create the Lookup Table
First, set up the lookup table
1. In G3:G5, type the percentages: 67%, 33%, 0%
2. In H3, enter the formula: =PERCENTILE($D$2:$D$11,G3)
3. Copy the formula down to rows 4 and 5
4. Format cells H3:H5 in Wingding3 font
5. Use Excel’s Insert Symbols feature to add the up, right, and down arrows in those cells, from the Wingdings 3 font.
NOTE: You could use different percentages, or just type values into H3:H5
Add the Custom Icons
Next, create the icons in column C:
1. In cell C2 enter the formula that creates the icon:
=IF(D2="","",IF(D2>=$H$3,$I$3,IF(D2>=$H$4,$I$4,$I$5)))
2. Copy the formula down to cell C11
3. Format cells C2:C11 with Wingding3 font, and yellow font color
4. Select cells C2:C11
5. On the Ribbon’s Home tab, click Conditional Formatting, then click New Rule
6. Click Use a Formula to Determine Which Cells to Format
7. For the formula, enter: =$B2<$H$4
8. Click the Format button, and select Green as the font colour, then click OK.
9. Click New Rule, and click Use a Formula to Determine Which Cells to Format
10. For the formula,enter: =$B2>$H$3
11. Click the Format button, and select Red as the font colour, then click OK.
12. Click OK
13. To make the icons appear to be in the same cell as the number, you can create an outside border around the two cells.
|
|
| pus acum 7 ani |
|