USU  ››  Zvirongwa zvebhizimusi otomatiki  ››  Chirongwa chechitoro chemaruva  ››  Mirayiridzo yepurogiramu yechitoro chemaruva  ›› 

Kusimudzira kukosha ine gradient kumashure

Aya maficha anowanikwa chete muStandard uye Professional chirongwa masisitimu.

Pano takatodzidza kushandisa conditional formatting nemifananidzo.

Gradient uchishandisa mavara maviri

Uye zvino ngatipindei mune module "Sales" simbisa iyo yakakosha mirairo uchishandisa gradient. Kuti tiite izvi, tinoshandisa murairo wagara uchizivikanwa "Conditional Formatting" .

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

Muhwindo rinoonekwa, mamiriro ekare ekugadzirisa data anogona kutowedzerwa. Kana zvirizvo, tinya bhatani re' Edit '. Uye kana pasina mamiriro, wobva wadzvanya bhatani re' Nyowani '.

Tevere, mune rondedzero yezvakakosha mhedzisiro, tanga wasarudza kukosha ' Fomati ese maseru zvichienderana nehunhu hwawo kuburikidza nemhando mbiri dzemavara '. Zvadaro sarudza mavara emutengo muduku uye mukuru.

Rudzi runogona kusarudzwa zvese kubva pane rondedzero uye kushandisa chiyero chekusarudza ruvara.

Izvi ndizvo zvinoita munhu anonhonga ruvara.

Mushure meizvozvo, iwe unozodzokera kune yapfuura hwindo, umo iwe wauchazoda kuve nechokwadi chekuti yakakosha mhedzisiro ichashandiswa zvakananga kune iyo ' Inobhadhara ' munda.

Izvi ndizvo zvichange zvakaita mhedzisiro yacho. Iyo inonyanya kukosha kurongeka, iyo yakasvibira kumashure kwesero ichave. Kusiyana nekushandisa seti yemifananidzo ine sarudzo yakadaro, kune yakawanda yakawanda mimvuri yepakati kukosha.

Gradient uchishandisa mavara matatu

Asi iwe unogona kugadzira gradient uchishandisa mavara matatu. Kune rudzi urwu rwekuita kwakakosha, sarudza ' Fomati ese maseru zvichienderana nehunhu hwawo mumhando mitatu yemavara '.

Nenzira imwecheteyo, sarudza mavara uye shandura zvakakosha zvigadziriso kana zvichidikanwa.

Muchiitiko ichi, chigumisiro chichatoita seizvi. Iwe unogona kuona kuti ruvara rwemavara rwakapfuma zvikuru.

Chinja font

Iwe unogona kuchinja kwete chete ruvara rwemashure, asiwo font .

Ona pazasi mamwe misoro inobatsira:

• Kusimudzira kukosha neseti yemifananidzo
• Conditional Formatting
• Kusvika pakutanga

• Dhawunirodha chirongwa nekudzidziswa kunopindirana