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

Batanidza Chati muMakoshi Akaratidzwa

Aya maficha anowanikwa chete muStandard uye Professional chirongwa masisitimu.

Apa tadzidza shandura font kune conditional formatting.

Embed Chart

Uye zvino ngatipindei mune module "Sales" for column "Kubhadhara" pachinzvimbo chekushandura ruvara rwesero, ngatiedzei kumisa chati yese. Kuti tiite izvi, tinoenda kumurairo watinoziva kare "Conditional Formatting" .

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

Simbisa iyo ' Ruvara chiyero ' mutemo uye tinya pane ' Rongedza ' bhatani.

Sarudza iyo yakakosha mhedzisiro inonzi ' Fomati ese maseru zvichienderana nehunhu hwavo kuburikidza nedata panhi .

Paunoshandisa iyi yakakosha mhedzisiro, chati yakazara ichaonekwa mukoramu yakasarudzwa, iyo inoratidza kukosha kweiyo yega yega. Iyo yakareba bhaa yechati, inonyanya kukosha kurongeka.

Mavara akasiyana echati

Zvinokwanisika kushandura chimiro chechati.

Kwete chete iwe unogona kushandura ruvara rwechati, asi iwe unogona zvakare kugovera rakasiyana ruvara rwehutsika husina kunaka.

Muchiitiko chedu, kudzoka kwechigadzirwa kucharatidzwa mune rumwe ruvara.

Value Rating

Verenga nezve value rating .

Ona pazasi mamwe misoro inobatsira:

• Value Rating
• Conditional Formatting
• Kusvika pakutanga

• Dhawunirodha chirongwa nekudzidziswa kunopindirana