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
Favorieten/bladwijzers