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

Conditional Formatting

Aya maficha anowanikwa chete muStandard uye Professional chirongwa masisitimu.

Nyora pasina zvakakosha mhedzisiro

Kana tikapinda module "Sales" , tinogona kuona chimwe chinhu chakaita sechinyorwa ichi.

Zvese zvakashongedzwa uye zvakanaka. Asi nekuratidzwa kwakadaro kwechinyorwa chemirairo, mushandisi anogona kusateerera kune zvakakosha. Semuenzaniso, zvinodikanwa kuita kuti maodha emari yakakura ioneke seyakanyanya kukosha.

Kusikwa kwechokwadi chakawedzerwa

Kuti uite izvi, unogona kudzvanya-kurudyi uye sarudza murairo "Conditional Formatting" . Izvi zvinoreva kuti kutaridzika kwezvinyorwa kuchashandurwa zvichienderana nemamiriro ezvinhu.

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 '.

Muhwindo rinotevera, iwe uchakwanisa kusarudza yakakosha maitiro.

Mifananidzo yakaiswa

Ona kuti ungashandisa sei seti yemifananidzo .

kumashure gradient

Tsvaga kuti iwe unogona sei kusimbisa zvakakosha zvakakosha kwete nemufananidzo, asi ne gradient background .

Shandura Mafonti

Iwe haugone kuchinja kwete ruvara rwekumashure, asi ruvara uye saizi font .

Embed Chart

Kune kunyange mukana wakasarudzika - embed chati .

Value Rating

Verenga nezve value rating .

Unique values kana duplicate

Iyo purogiramu ichakuratidza iwe mune chero tafura akasiyana tsika kana zvakapetwa .

Ona pazasi mamwe misoro inobatsira:

• Kugovera mifananidzo
• Kusimudzira kukosha neseti yemifananidzo
• Kusimudzira kukosha ine gradient kumashure
• Simbisa kukosha mune imwe fonti
• Batanidza Chati muMakoshi Akaratidzwa
• Value Rating
• Tsvaga yakasarudzika tsika kana zvakapetwa
• Sales
• Kusvika pakutanga

• Dhawunirodha chirongwa nekudzidziswa kunopindirana