USU  ››  Zvirongwa zvebhizimusi otomatiki  ››  Chirongwa chekiriniki  ››  Mirayiridzo yechirongwa chekurapa  ›› 

Simbisa ruvara rwekumashure

Aya maficha anowanikwa chete muStandard uye Professional chirongwa masisitimu.

Pano takatodzidza kushandisa conditional formatting nemifananidzo.

Gradient uchishandisa mavara maviri

Uye zvino ngatipindei mune module "Varwere" sarudza vanhu vanonyungudutsa zvakanyanya uchishandisa gradient. Iyo purogiramu ichatibatsira kuratidza humwe hunhu neruvara rwekumashure. 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 uchafanirwa kuve nechokwadi chekuti yakakosha mhedzisiro ichaiswa zvakananga kune iyo ' Total yakashandiswa ' munda.

Izvi ndizvo zvichange zvakaita mhedzisiro yacho. Kuwanda kunoita mari nemurwere mukiriniki yako, ndiko kunobva kwawedzera kusvibira kwesero. 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 mumatatu emavara '.

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

Muchiitiko ichi, chigumisiro chichatoita seizvi. Iwe unogona kuona kuti palette yemavara epakati yakapfuma zvakanyanya.

Shandura Mafonti

Iwe unogona kuchinja kwete chete ruvara rwemashure, asiwo font .

Ona pazasi mamwe misoro inobatsira:

• Kuona ruzivo nemifananidzo
• Simbisa Zvinhu Zvinokosha
• Kusvika pakutanga

• Dhawunirodha chirongwa nekudzidziswa kunopindirana