Aya maficha anowanikwa chete muStandard uye Professional chirongwa masisitimu.
Pano takatodzidza kushandisa conditional formatting ine ruvara rwekumashure.
Uye zvino ngatipindei mune module "Sales" shandura font yeavo maodha ane chikwereti. Ipapo vashandi havazokanganwe kutora mari yakawedzerwa. Tinoenda kuchikwata chatinoziva kare "Conditional Formatting" .
Ndapota verenga kuti sei iwe usingazokwanisi kuverenga mirairo yakafanana uye kushanda pahwindo rinoonekwa.
Kunyangwe isu tatova nechimiro chimwe chekusimbisa kukosha mutafura, tinya bhatani re' Nyowani ' kuti uwedzere mamiriro matsva. Mumuenzaniso uyu, tinokuratidza kuti mitemo yakawanda yekumisikidzwa kwezvimiso inogona kusanganiswa sei.
Muhwindo rinoonekwa, sarudza yakakosha maitiro ' Fomati chete maseru ane '. Wobva wasarudza chiratidzo chekuenzanisa ' Mukuru Kupfuura '. Isa kukosha ku ' 0 '. Mamiriro acho achave: ' kukosha kwakakura kupfuura zero '. Uye pakupedzisira inosara chete kugadzirisa font yemhando dzakadaro nekudzvanya pane ' Format ' bhatani.
Tinoda kukwevera pfungwa dzevashandisi kune maodha ane chikwereti. Zvose zvine chekuita nemari zvakakosha zvikuru. Naizvozvo, isu tinogadzira iyo font yakashinga , yakakura uye yakatsvuka .
Tichadzokera kuhwindo rakapfuura, chete ikozvino richange riine maviri ekufomatidza mamiriro. Kune yedu yechipiri mamiriro, sarudza iyo ' Chikwereti ' munda kuitira kuti ndipo panochinja font.
Somugumisiro, tichawana mufananidzo uyu. Pamusoro pekusimbisa mirairo yakakosha, huwandu hwechikwereti zvino huchaonekwa zvakanyanya.
Pane akakosha mamiriro kwaunoda kushandura font mubhokisi remavara . Semuenzaniso, ngatiisei module "Clients" uye nyatsoteerera kumunda "Nharembozha" . Iwe unogona kuzviita kuitira kuti vatengi vane nhamba dzenhare dzeimwe cellular opareta, semuenzaniso, kutanga ne ' +7999 ', dzakasimbiswa.
Sarudza timu "Conditional Formatting" . Zvadaro tinowedzera mutemo mutsva wefomati ' Shandisa fomula kuona kuti ndeapi maseru ekufomatidza '.
Zvadaro, nyatsonyora zvakare fomula, iyo inoratidzwa mumufananidzo uri pasi apa.
Mune iyi fomula, tiri kutsvaga zvinyorwa zvinofanirwa kuverengerwa mune chaiyo ndima. Zita remunda rinoratidzwa mumabhuraketi akaenzana.
Zvadaro zvinongosara chete kusarudza font yezvinokosha zvinozoratidzwa. Ngatisandurei chete ruvara nekukora kwemavara.
Ngatiisei mamiriro matsva ekufomatidza kumunda we' Cell Phone '.
Uye heino mhedzisiro!
Kune kunyange mukana wakasarudzika - embed chati .
Ona pazasi mamwe misoro inobatsira:
Universal Accounting System
2010 - 2024