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

Kusimudzira kukosha neseti yemifananidzo

Aya maficha anowanikwa chete muStandard uye Professional chirongwa masisitimu.

Mifananidzo yakaiswa

Handei mumodule "Sales" simbisa iyo yakakosha mirairo uchishandisa seti yemifananidzo inooneka. Nokuda kweizvi tinoshandisa murairo "Conditional Formatting" .

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

Hwindo rekuwedzera zvakakosha manyorerwo etafura achaonekwa. Kuti uwedzere mamiriro matsva ekugadzirisa data kwairi, tinya bhatani re' Nyowani '.

Kuti utange, sarudza ' Fomati ese maseru zvichienderana nehunhu hwavo uchishandisa seti yemifananidzo '. Uye ipapo pazasi pehwindo kubva pane yekudonha-pasi rondedzero, sarudza seti yemifananidzo yaunonyanya kufarira.

Yekutanga yekupinda inowedzerwa kune runyorwa rwemafomati mamiriro. Mariri, iwe uchada kusarudza munda watichashandisa iyo yakakosha maitiro. Sarudza munda ' Kubhadhara '.

Ona kuti mazita ekutengesa akachinja sei. Iye zvino pane denderedzwa dzvuku pedyo nekutengesa kuduku. Avhareji yekutengesa inomakwa nedenderedzwa reorenji. Uye iyo yakanyanya kudiwa mirairo mikuru inomisikidzwa nedenderedzwa regirinhi.

Mushure meizvozvo, vashandi vako vanonyatsoona kuti ndeupi odha inoda kuongororwa zvakanyanya.

Shandura mafomati anemiganho

Iwe unogona kuedza nekusarudza seti dzakasiyana dzemifananidzo. kuti uchinje "conditional formatting" , isa mutemo wezita rimwe chete zvakare. Dzvanya bhatani rekuti ' Shandura '.

Zvino sarudza imwe seti yemifananidzo. Semuenzaniso, iyo mifananidzo iyo ichasiyana kwete muvara, asi muchiyero chekuzadza. Uye pamusoro peiyo yekudonhedza-pasi rondedzero yekusarudza mapikicha, kune zvakare akakosha maitiro marongero aunogona kuedza kuchinja.

Unowana mhedzisiro iyi.

Isa mufananidzo wako kune kukosha

Pachine mukana isa mufananidzo wako kune imwe kukosha kuti ujekeswe zvakanyanya.

kumashure gradient

Tsvaga kuti ungasimbisa sei zvakakosha zvakakosha kwete nemufananidzo, asi ne gradient background .

Ona pazasi mamwe misoro inobatsira:

• Kugovera mifananidzo
• Kusimudzira kukosha ine gradient kumashure
• Conditional Formatting
• Kusvika pakutanga

• Dhawunirodha chirongwa nekudzidziswa kunopindirana