01 ka 01
I-Excel Shading Rows / Columns Formula
Esikhathini esiningi, ukufometha okunemibandela kusetshenziselwa ukushintsha imibala yeselula noma yefonti ekuphenduleni idatha efakwe esiteleni njengosuku lokudlula isikhathi noma izindleko zebhajethi eziphakeme kakhulu, futhi ngokuvamile lokhu kwenziwa ngokusebenzisa izimo ezilungiselelwe i-Excel.
Ngaphezu kokukhethwa kwangaphambi kokusetha, noma kunjalo, kungenzeka futhi ukudala imithetho yendlela yokufometha enemibandela esebenzayo usebenzisa amafomu e-Excel ukuhlola izimo ezichazwe ngumsebenzisi.
Enye ifomula enjalo ehlanganisa imisebenzi ye- MOD ne- ROW , ingasetshenziselwa ukuthutha ngokuzenzakalelayo imigqa eminye yedatha engenza idatha yokufunda kumashidi amakhulu okusebenza , kube lula kakhulu.
Shading Dynamic
Enye inzuzo yokusebenzisa ifomula yokwengeza shading irowu yukuthi shading yinto enamandla okusho ukuthi iyakushintsha uma inani lemigqa lishintsha.
Uma imigqa ingeniswa noma isusiwe u-shading umugqa ulungise uqobo ngokwabo ukuze ugcine iphethini.
Qaphela: Imigqa engezona akuyona kuphela okukhethwa kukho ngale fomula. Ngokuyishintsha kancane, njengoba kuxoxwa ngezansi, ifomula ingafaka umthunzi noma yiliphi iphethini yemigqa. Kungasetshenziswa ngisho nokuthunga amakholomu esikhundleni semigqa uma ukhetha.
Isibonelo: Shading Rows Formula
Isinyathelo sokuqala ukugqamisa ububanzi bamaseli abukiselwe kusukela ifomula kuphela ithinta lawa maseli akhethiwe.
- Vula ishidi lokusebenzela le-Excel-ishidi lokusebenzela elingenalutho lizosebenza kulolu hlelo
- Qinisekisa ububanzi bamaseli ekhasini lokusebenzela
- Chofoza kuthebhu yaseKhaya ye- ribbon
- Chofoza kusithonjana sokufometha okunemibandela ukuvula imenyu yehla
- Khetha ukhetho olusha lokuvula i- New Formatting Rule dialog box
- Chofoza ku- Sebenzisa Ifomula ukucacisa ukuthi yiliphi amaseli ukufometha okukhethwa kukho ohlwini oluphezulu kwebhokisi lengxoxo
- Faka ifomula elandelayo ebhokisini elingezansi kwamanani wefomathi lapho leli xabiso liyiqiniso langempela engxenyeni engezansi yebhokisi lebhokisi = MOD (ROW (), 2) = 0
- Chofoza inkinobho yefomathi ukuze uvule ibhokisi lengxoxo yefomathi yefomathi
- Cindezela ithebhu yokugcwalisa ukuze ubone izinketho zombala wangemuva
- Khetha umbala ozowasebenzisa ukufaka shayela eminye imigqa ebangeni elikhethiwe
- Chofoza OK ngokuphindwe kabili ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela
- Iminye imigqa ebangeni elikhethiwe kufanele manje ifakwe umbala nombala ogciniwe ogciniwe
Ukuhumusha ifomu
Indlela le fomula efundwa yi-Excel yiyi:
- inombolo 2 efomini inquma ukuthi iphethini ye-shading liphinda njalo emgqeni wesibili ebangeni elikhethiwe
- isimo se = 0 kufomula sinquma ukuthi umugqa wokuqala ebangeni awuhlanganisiwe - okwenziwe ngoba lo mgca uvame ukuqukethe izihloko ezinokufometha kwazo.
Yiziphi i-MOD ne-ROW Do
Iphethini incike kumsebenzi we-MOD kufomula. I-MOD eyenza ihlukanisa inombolo yomugqa (enqunywe umsebenzi we-ROW) ngenombolo yesibili ngaphakathi kubakaki iphinda ibuyisele insalela noma i-modulus njengoba ibizwa ngezinye izikhathi.
Kuleli qophelo, ukufometha okunemibandela kuthatha futhi kuqhathanisa le modulus nenombolo emva kwesibonakaliso esifanayo. Uma kunomdlalo (noma ngaphezulu ngokunembile uma isimo singu-TRUE), umugqa uvulekile, uma izinombolo ngakwesinye isignesha esilinganayo zingavumelani, isimo si-FALSE futhi akukho shading eyenzeka kulolo hlu.
Isibonelo, esithombeni esingenhla, uma umugqa wokugcina ebangeni elikhethiwe 18 lihlukaniswe ngu-2 ngomsebenzi we-MOD, okusele ngu-0, ngakho isimo se-0 = 0 si-TRUE, futhi umugqa uvulekile.
Umzila 17, ngakolunye uhlangothi, uma uhlukaniswe ngu-2 ushiya ingxenye e-1, engalingani ne-0, ngakho-ke lo mzila ushiywe ungaxhunyiwe.
Shading Columns Esikhundleni Semigqa
Njengoba kukhonjisiwe, amafomula asetshenziselwa ukuthungatha imigqa ehlukile ingashintshwa ukuze avumele ukufaka shalamu namakholomu. Ukuguqulwa okudingekayo ukuthi usebenzise umsebenzi we-COLUMN esikhundleni somsebenzi we-ROW kwifomula. Ngokwenza kanjalo, ifomula izobukeka kanje:
= I-MOD (COLUMN (), 2) = 0Qaphela: Izinguquko kwifomula ye-shading yokuguqula iphethini yokufiphaza echazwe ngezansi futhi isebenza kumfomula ye-shading formula.
Shintsha ifomu, Shintsha i-Pattern Shading
Ukushintsha i-pattern shading kwenziwa kalula ngokushintsha noma yiziphi izinombolo ezimbili kwifomula.
- Ukuze ube ne-row shading iqale ngomugqa wokuqala esikhundleni sesibili, ekupheleni kwefomula, shintsha = 0 kuya = 1 ;
- Ukuze ube nomugqa wesithathu noma wesine owodwa esikhundleni somugqa ohlukile, shintsha 2 kufomula ibe ngu-3 noma 4.
Ukwahlukana akukwazi ukuba yiZero noma eyodwa
Inombolo ngaphakathi kubakaki ibizwa ngokuthi i- divisor ngoba yile namba ehlukanisa umsebenzi we-MOD. Uma ukhumbule emuva kumaklasi wezibalo okwahlukaniswa yi-zero akuvumelekile futhi akuvunyelwe ku-Excel noma. Uma uzama ukusebenzisa i-zero ngaphakathi kubakaki esikhundleni se-2, njenge:
= MOD (ROW (), 0) = 2ngeke uthole shading nhlobo ebangeni.
Ngaphandle kwalokho, uma uzama ukusebenzisa inombolo eyodwa kumchazi ngakho ifomula ibonakala:
= MOD (ROW (), 1) = 0wonke umugqa ohlangothini uzovuleka. Lokhu kwenzeka ngoba noma iyiphi inombolo ehlukaniswe ngenye indlela ishiya insalela ye-zero, futhi khumbula, uma isimo se-0 = 0 singu-TRUE, umugqa uvuliwe.
Shintsha i-Operator, Shintsha i-Pattern Shading
Ukuze ushintshe ngempela iphethini, shintsha isimo somgomo noma sokuqhathanisa (isibonakaliso esifanayo) esetshenziselwa ifomula ukuya ngaphansi kwesignesha (<).
Ngokushintsha = 0 kuya <2 (ngaphansi kwezingu-2) isibonelo, imigqa emibili ingahlanganiswa. Yenze lokho <3, futhi ukukhwabanisa kuzokwenziwa ngamaqembu emigqa emithathu.
I-caveat kuphela yokusebenzisa okungaphansi kuka-opharetha ukuqinisekisa ukuthi inombolo ngaphakathi kubakaki ibanzi kunombhalo ekupheleni kwefomula. Uma kungenjalo, wonke umugqa ohlangothini uzokhishwa.