Weergegeven resultaten: 1 t/m 10 van 24

Discussie: Excel

Threaded View

  1. 5 February 2006, 21:54 #1
    minoe
    minoe is offline
    PC-Freak   minoe's schermafbeelding
    Geregistreerd
    5 November 2005
    Locatie
    waregem
    Berichten
    1.429
    Bedankjes
    533
    Bedankt
    171 keer in 134 posts

    Excel

    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
    Laatst gewijzigd door minoe; 5 February 2006 om 21:55
« Vorige discussie | Volgende discussie »

Discussie informatie

Users Browsing this Thread

Momenteel bekijken 1 gebruikers deze discussie. (0 leden en 1 gasten)

Soortgelijke discussies

  1. Excel: wat is veranderd ?
    Door fryum in forum Office
    Reacties: 9
    Laatste bericht: 20 February 2006, 09:17
  2. Tip voor excel
    Door Perigo17 in forum Office
    Reacties: 22
    Laatste bericht: 3 February 2006, 17:51
  3. nog ne keer Excel
    Door veysie in forum Office
    Reacties: 4
    Laatste bericht: 1 December 2005, 20:49
  4. excel
    Door marjo58 in forum Office
    Reacties: 4
    Laatste bericht: 30 August 2005, 13:45

Favorieten/bladwijzers

Favorieten/bladwijzers

Regels voor berichten

  • Je mag geen nieuwe discussies starten
  • Je mag niet reageren op berichten
  • Je mag geen bijlagen versturen
  • Je mag niet je berichten bewerken
  •  

Forumregels