USU  ››  Zvirongwa zvebhizimusi otomatiki  ››   ››   ›› 

Tsvaga yakasarudzika tsika kana zvakapetwa

Aya maficha anowanikwa chete muStandard uye Professional chirongwa masisitimu.

Apa takatarisa nzira yekuvaka mwero wezvakanakisa kana zvakaipa.

Unique values

Zvino ngatipindei "Sales" sarudza otomatiki ivavo "buyers" vakatenga zvinhu kubva kwatiri kekutanga. Kuti tiite izvi, tinoenda kumurairo watinoziva kare "Conditional Formatting" .

Ndapota verenga kuti nei usingazokwanisi kuverenga mirairo yakafanana uye kushanda pahwindo rinoonekwa.

Kana uchine mitemo yefomati kubva kumienzaniso yapfuura, bvisa yese. Wobva wawedzera imwe nyowani uchishandisa bhatani re' Nyowani '.

Tevere, sarudza iyo ' Format yakasarudzika tsika chete ' kukosha kubva pane rondedzero. Wobva wadzvanya bhatani re' Format ' uye ita kuti font ishinge.

Isa mafomati aya kuchikamu che' Mutengi '.

Nekuda kweizvozvo, tichaona vatengi vekutanga. Vatengi vatsva vanotenga chigadzirwa kubva kwatiri kekutanga vachamira pachena.

Duplicate kuratidza

Nenzira imwecheteyo, iwe unogona kuwana zvese zvakapetwa. Ngatiratidze mune rumwe ruvara mazita evatengi vakatenga zvinhu kubva kwatiri kakawanda. Kuti uite izvi, wedzera mamiriro matsva ekugadzirisa.

Mamiriro ese ari maviri ekufomatidza anofanirwa kuiswa kune imwechete munda.

Iye zvino mune rondedzero yekutengesa, vatengi vedu venguva dzose vanoratidzirwa mune inonakidza ruvara rwegirinhi.

Tsvaga kana maduplicate achitenderwa munzvimbo dzakakosha.

Ona pazasi mamwe misoro inobatsira:

• Maduplicate anobvumidzwa here?
• Value Rating
• Conditional Formatting
• Kusvika pakutanga

• Dhawunirodha chirongwa nekudzidziswa kunopindirana