Hallo.Heeft er iemand (veel) ervaring met excel.Zou al dezelfde getallen in mijn cellen willen markeren in het zwart.Nu doe ik het één voor één ,maar zou al dezelfde getallen in één keer willen markeren.Zou dit lukken.Werk met office 2000.Hieronder een vb.
<TABLE borderColor=#000000 cellSpacing=3 cellPadding=12 width=450 border=1><TBODY><TR><TD vAlign=bottom width="10%" bgColor=#000000 height=0>2
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>3
</TD><TD vAlign=bottom width="10%" height=0>6
</TD><TD vAlign=bottom width="10%" height=0>8
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>10
</TD><TD vAlign=bottom width="10%" height=0>11
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>12
</TD><TD vAlign=bottom width="10%" height=0>21
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>22
</TD><TD vAlign=bottom width="10%" height=0>25
</TD></TR><TR><TD vAlign=bottom width="10%" bgColor=#000000 height=0>3
</TD><TD vAlign=bottom width="10%" height=0>8
</TD><TD vAlign=bottom width="10%" height=0>11
</TD><TD vAlign=bottom width="10%" height=0>15
</TD><TD vAlign=bottom width="10%" height=0>21
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>28
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>29
</TD><TD vAlign=bottom width="10%" height=0>36
</TD><TD vAlign=bottom width="10%" height=0>39
</TD><TD vAlign=bottom width="10%" height=0>42
</TD></TR><TR><TD vAlign=bottom width="10%" bgColor=#000000 height=0>3
</TD><TD vAlign=bottom width="10%" height=0>7
</TD><TD vAlign=bottom width="10%" height=0>8
</TD><TD vAlign=bottom width="10%" height=0>9
</TD><TD vAlign=bottom width="10%" height=0>15
</TD><TD vAlign=bottom width="10%" height=0>16
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>29
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>31
</TD><TD vAlign=bottom width="10%" height=0>41
</TD><TD vAlign=bottom width="10%" height=0>42
</TD></TR><TR><TD vAlign=bottom width="10%" bgColor=#000000 height=0>10
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>12
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>14
</TD><TD vAlign=bottom width="10%" height=0>19
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>22
</TD><TD vAlign=bottom width="10%" height=0>25
</TD><TD vAlign=bottom width="10%" height=0>31
</TD><TD vAlign=bottom width="10%" height=0>37
</TD><TD vAlign=bottom width="10%" height=0>38
</TD><TD vAlign=bottom width="10%" height=0>42
</TD></TR><TR><TD vAlign=bottom width="10%" height=0>4
</TD><TD vAlign=bottom width="10%" height=0>5
</TD><TD vAlign=bottom width="10%" height=0>6
</TD><TD vAlign=bottom width="10%" height=0>9
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>12
</TD><TD vAlign=bottom width="10%" height=0>24
</TD><TD vAlign=bottom width="10%" height=0>27
</TD><TD vAlign=bottom width="10%" height=0>38
</TD><TD vAlign=bottom width="10%" height=0>40
</TD><TD vAlign=bottom width="10%" height=0>42
</TD></TR><TR><TD vAlign=bottom width="10%" bgColor=#000000 height=0>3
</TD><TD vAlign=bottom width="10%" height=0>5
</TD><TD vAlign=bottom width="10%" height=0>7
</TD><TD vAlign=bottom width="10%" height=0>8
</TD><TD vAlign=bottom width="10%" height=0>9
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>14
</TD><TD vAlign=bottom width="10%" height=0>16
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>26
</TD><TD vAlign=bottom width="10%" height=0>27
</TD><TD vAlign=bottom width="10%" height=0>30
</TD></TR><TR><TD vAlign=bottom width="10%" bgColor=#000000 height=0>2
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>3
</TD><TD vAlign=bottom width="10%" bgColor=#ffff00 height=0>7
</TD><TD vAlign=bottom width="10%" bgColor=#ffff00 height=0>24
</TD><TD vAlign=bottom width="10%" bgColor=#ffff00 height=0>25
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>28
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>29
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>31
</TD><TD vAlign=bottom width="10%" bgColor=#ffff00 height=0>37
</TD><TD vAlign=bottom width="10%" bgColor=#ffff00 height=0>42
</TD></TR><TR><TD vAlign=bottom width="10%" bgColor=#000000 height=0>2
</TD><TD vAlign=bottom width="10%" height=0>8
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>10
</TD><TD vAlign=bottom width="10%" height=0>17
</TD><TD vAlign=bottom width="10%" height=0>19
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>22
</TD><TD vAlign=bottom width="10%" height=0>27
</TD><TD vAlign=bottom width="10%" height=0>33
</TD><TD vAlign=bottom width="10%" height=0>36
</TD><TD vAlign=bottom width="10%" height=0>39
</TD></TR><TR><TD vAlign=bottom width="10%" bgColor=#000000 height=0>3
</TD><TD vAlign=bottom width="10%" height=0>8
</TD><TD vAlign=bottom width="10%" height=0>17
</TD><TD vAlign=bottom width="10%" height=0>19
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>23
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>26
</TD><TD vAlign=bottom width="10%" height=0>34
</TD><TD vAlign=bottom width="10%" height=0>37
</TD><TD vAlign=bottom width="10%" height=0>41
</TD><TD vAlign=bottom width="10%" height=0>42
</TD></TR><TR><TD vAlign=bottom width="10%" height=0>4
</TD><TD vAlign=bottom width="10%" height=0>11
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>12
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>22
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>23
</TD><TD vAlign=bottom width="10%" height=0>27
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>28
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>29
</TD><TD vAlign=bottom width="10%" height=0>37
</TD><TD vAlign=bottom width="10%" height=0>39
</TD></TR><TR><TD vAlign=bottom width="10%" height=0>4
</TD><TD vAlign=bottom width="10%" height=0>6
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>10
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>12
</TD><TD vAlign=bottom width="10%" height=0>16
</TD><TD vAlign=bottom width="10%" height=0>19
</TD><TD vAlign=bottom width="10%" height=0>25
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>26
</TD><TD vAlign=bottom width="10%" height=0>41
</TD><TD vAlign=bottom width="10%" height=0>42
</TD></TR><TR><TD vAlign=bottom width="10%" height=0>5
</TD><TD vAlign=bottom width="10%" height=0>11
</TD><TD vAlign=bottom width="10%" height=0>19
</TD><TD vAlign=bottom width="10%" height=0>21
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>26
</TD><TD vAlign=bottom width="10%" height=0>27
</TD><TD vAlign=bottom width="10%" height=0>30
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>31
</TD><TD vAlign=bottom width="10%" height=0>36
</TD><TD vAlign=bottom width="10%" height=0>40
</TD></TR><TR><TD vAlign=bottom width="10%" height=0>7
</TD><TD vAlign=bottom width="10%" height=0>13
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>14
</TD><TD vAlign=bottom width="10%" height=0>21
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>23
</TD><TD vAlign=bottom width="10%" bgColor=#000000 height=0>26
</TD><TD vAlign=bottom width="10%" height=0>30
</TD><TD vAlign=bottom width="10%" height=0>37
</TD><TD vAlign=bottom width="10%" height=0>38
</TD><TD vAlign=bottom width="10%" height=0>42
</TD></TR></TBODY></TABLE>
Zou bijvoorbeeld het getal 21 in één keer willen markeren in het zwart.
Hoe ga ik tewerk
Weergegeven resultaten: 1 t/m 10 van 24
Discussie: Excel
-
5 February 2006, 21:54 #1PC-Freak
- Geregistreerd
- 5 November 2005
- Locatie
- waregem
- Berichten
- 1.429
- Bedankjes
- 540
- Bedankt
- 171 keer in 134 posts
Excel
Laatst gewijzigd door minoe; 5 February 2006 om 21:55
-
5 February 2006, 21:57 #2Erelid
- Geregistreerd
- 3 May 2005
- Berichten
- 6.700
- Bedankjes
- 1.651
- Bedankt
- 8.252 keer in 3.245 posts
Re: Excel
Via opmaak > voorwaardelijke opmaak.
Als cel gelijk is aan 21 > opmaak > cel zwart kleuren.
Voilà, alle cellen waar 21 in staat worden zwart gekleurd.
Beter ten halve gekeerd dan helemaal verkeerd.
-
De volgende gebruiker bedankt g_man voor deze nuttige post:
minoe ( 6 February 2006)
-
5 February 2006, 22:23 #3PC-Freak
- Geregistreerd
- 5 November 2005
- Locatie
- waregem
- Berichten
- 1.429
- Bedankjes
- 540
- Bedankt
- 171 keer in 134 posts
Re: Excel
Ben via opmaak geweest maar zie daar geen voorwaardelijke opmaak staan ze.
Oorspronkelijk geplaatst door g_man
Via opmaak > voorwaardelijke opmaak.
Als cel gelijk is aan 21 > opmaak > cel zwart kleuren.
Voilà, alle cellen waar 21 in staat worden zwart gekleurd.
Wel automatische opmaak ,maar dan moet ik meer dan één cel aanduiden terwijl het de bedoeling is om een getal in te typen of aan te duiden en dat hij dan zelf al dezelfde getallen in werkblad(grafiek) automatisch in het zwart kleurt
-
5 February 2006, 23:57 #4Geek
- Geregistreerd
- 10 May 2005
- Locatie
- Hulshout (Antwerpen)
- Berichten
- 3.027
- Bedankjes
- 59
- Bedankt
- 3.143 keer in 2.293 posts
Re: Excel
Selecteer heel uw werkbad. Opmaak - Voorwaardelijke opmaak - Celwaarde - is gelijk aan - 21 - Opmaak - Tabblad Patronen - Opvulkleuren: klik op een kleur - OK - OK Oorspronkelijk geplaatst door minoe
Door gebruik te maken van "Toevoegen" kunt u dit doen met maximum drie verschillende getallen.J.W.
Google is uw vriend
-
De volgende gebruiker bedankt J.W. voor deze nuttige post:
minoe ( 6 February 2006)
-
6 February 2006, 00:16 #5PC-Freak
- Geregistreerd
- 5 November 2005
- Locatie
- waregem
- Berichten
- 1.429
- Bedankjes
- 540
- Bedankt
- 171 keer in 134 posts
Re: Excel
Oei.Misverstand.Sorry gasten.Mijn tabel staat in works spreadsheet maar niet in excel.Heb eens gechekt bij excel en daar staat voorwaardelijke opmaak wel bij.Zou ditzelfde ook gaan bij works spreadsheet.
Heb geprobeerd met excel en dit werkt.Bedankt voor de uitleg.Laatst gewijzigd door minoe; 6 February 2006 om 00:26
-
6 February 2006, 00:57 #6PC-Freak
- Geregistreerd
- 5 November 2005
- Locatie
- waregem
- Berichten
- 1.429
- Bedankjes
- 540
- Bedankt
- 171 keer in 134 posts
Re: Excel
Zou dit ook lukken.Heb tien nrs.in een rij staan en zou telkens ,wanneer ik een bepaald aantal vakjes in het zwart gekleurd heb,het aantal resterende vakjes(niet zwart) in cijfer willen hebben in de kolom naast tien cijfers.Dus telkens ik deze rij verander automatisch de overgebleven cellen in aantal weergeven.Zie vb. hieronder
<TABLE style="WIDTH: 386pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=511 border=0 x:str><COLGROUP><COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1792" width=49><COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1792" span=8 width=49><COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1792" width=49><COL style="WIDTH: 16pt; mso-width-source: userset; mso-width-alt: 768" width=21><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl31 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: black 1.5pt solid; WIDTH: 37pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: black" align=right width=49 height=17 x:num>2</TD><TD class=xl38 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 37pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" align=right width=49 x:num>3</TD><TD class=xl26 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 37pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right width=49 x:num>6</TD><TD class=xl26 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 37pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right width=49 x:num>8</TD><TD class=xl38 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 37pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" align=right width=49 x:num>10</TD><TD class=xl26 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 37pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right width=49 x:num>11</TD><TD class=xl38 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 37pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" align=right width=49 x:num>12</TD><TD class=xl26 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 37pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right width=49 x:num>21</TD><TD class=xl32 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 37pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right width=49 x:num>22</TD><TD class=xl28 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: black 1.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 37pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right width=49 x:num>25</TD><TD class=xl40 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 16pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right width=21 x:num>6</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl34 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: black" align=right height=17 x:num>3</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>8</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>11</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>15</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>21</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>28</TD><TD class=xl39 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" align=right x:num>29</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>36</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>39</TD><TD class=xl29 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>42</TD><TD class=xl40 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>8</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl34 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: black" align=right height=17 x:num>3</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>7</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>8</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>9</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>15</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>16</TD><TD class=xl39 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" align=right x:num>29</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>31</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>41</TD><TD class=xl29 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>42</TD><TD class=xl40 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>8</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl34 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: black" align=right height=17 x:num>10</TD><TD class=xl39 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" align=right x:num>12</TD><TD class=xl39 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" align=right x:num>14</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>19</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>22</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>25</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>31</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>37</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>38</TD><TD class=xl29 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>42</TD><TD class=xl40 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>7</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl27 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:num>4</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>5</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>6</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>9</TD><TD class=xl39 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" align=right x:num>12</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>24</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>27</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>38</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>40</TD><TD class=xl29 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>42</TD><TD class=xl40 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>9</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl34 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: black" align=right height=17 x:num>3</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>5</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>7</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>8</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>9</TD><TD class=xl39 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" align=right x:num>14</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>16</TD><TD class=xl33 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>26</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>27</TD><TD class=xl29 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>30</TD><TD class=xl40 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>8</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl34 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: black" align=right height=17 x:num>2</TD><TD class=xl39 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" align=right x:num>3</TD><TD class=xl25 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: yellow" align=right x:num>7</TD><TD class=xl25 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: yellow" align=right x:num>24</TD><TD class=xl25 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: yellow" align=right x:num>25</TD><TD class=xl35 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" align=right x:num>28</TD><TD class=xl39 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" align=right x:num>29</TD><TD class=xl35 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" align=right x:num>31</TD><TD class=xl25 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: yellow" align=right x:num>37</TD><TD class=xl30 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: yellow" align=right x:num>42</TD><TD class=xl41 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: yellow" align=right x:num>5</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl36 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: black" align=right height=17 x:num>2</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>8</TD><TD class=xl39 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" align=right x:num>10</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>17</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>19</TD><TD class=xl37 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>22</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>27</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>33</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>36</TD><TD class=xl29 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>39</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl34 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: black 1.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: black" align=right height=17 x:num>3</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>8</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>17</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>19</TD><TD class=xl37 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>23</TD><TD class=xl37 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>26</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>34</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>37</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>41</TD><TD class=xl29 style="BORDER-RIGHT: black 1.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right x:num>42</TD><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>
Dus de rode cijfers=overgebleven(niet zwart)cellen in die rij
-
6 February 2006, 20:22 #7Erelid
- Geregistreerd
- 11 May 2005
- Berichten
- 1.020
- Bedankjes
- 41
- Bedankt
- 61 keer in 59 posts
Re: Excel
Misschien kan je met de functie aantal.als iets doen? Maar ik zie niet direct welk criterium je kan gebruiken.
-
6 February 2006, 21:20 #8mam@minatica
- Geregistreerd
- 10 May 2005
- Locatie
- Waasland
- Berichten
- 18.839
- Bedankjes
- 15.650
- Bedankt
- 37.027 keer in 15.348 posts
Re: Excel
=aantal.als(cel>0)?
Helpers altijd welkom! Contacteer één van onze admins voor meer info.
-
6 February 2006, 21:40 #9Geek
- Geregistreerd
- 10 May 2005
- Locatie
- Hulshout (Antwerpen)
- Berichten
- 3.027
- Bedankjes
- 59
- Bedankt
- 3.143 keer in 2.293 posts
Re: Excel
Dan mag er in die zwarte vakjes geen getal staan. En de eerste vraag was: vakjes met dezelfde getallen zwart maken!!!! Oorspronkelijk geplaatst door compuchrisje
J.W.
Google is uw vriend
-
6 February 2006, 21:48 #10Up-to-date
- Geregistreerd
- 13 November 2005
- Berichten
- 82
- Bedankjes
- 17
- Bedankt
- 18 keer in 15 posts
Re: Excel
Het spijt me, ik ken ook geen functie in Excel die toelaat de opmaak in een een getal of code weer te geven.
Binnen VB zou dit wel moeten lukken, maar ken hier veel te weinig van.
As je kan uitleggen wat je wenst te bereiken.
Misschien zijn er standaard oplossingen voorhanden.
Ciao,
G.F.
Discussie informatie
Users Browsing this Thread
Momenteel bekijken 1 gebruikers deze discussie. (0 leden en 1 gasten)
Soortgelijke discussies
-
Excel: wat is veranderd ?
Door fryum in forum OfficeReacties: 9Laatste bericht: 20 February 2006, 09:17 -
Tip voor excel
Door Perigo17 in forum OfficeReacties: 22Laatste bericht: 3 February 2006, 17:51 -
nog ne keer Excel
Door veysie in forum OfficeReacties: 4Laatste bericht: 1 December 2005, 20:49 -
excel
Door marjo58 in forum OfficeReacties: 4Laatste bericht: 30 August 2005, 13:45
Regels voor berichten
- Copyright © 2004 - 2019, Minatica.be
-
Powered by vBulletin®, versie 4.2.2
Copyright © 2024 vBulletin Solutions, Inc. - Design door Gert Bangels
Favorieten/bladwijzers