Nzira iri nyore
Sarudza huwandu hune misi pane pepa uye sarudza pane tab Kumba - Conditional Formatting - Cell Selection Rules - Date (Imba - Conditional Formatting - Simbisa Mitemo Yesero - Zuva Richiitika). Muhwindo rinovhurwa, sarudza yaunoda mwenje sarudzo kubva pane yekudonha-pasi runyorwa:
Yakaoma asi yakanaka nzira
Zvino ngationgororei dambudziko rakaoma uye rinonakidza. Ngatitii tine tafura huru yekugovera yezvimwe zvinhu:
Ndapota cherechedza zuva rekutumira. Kana zviri munguva yakapfuura, saka zvinhu zvakatounzwa - haufanirwe kunetseka. Kana iri mune ramangwana, saka tinofanira kuchengetedza nyaya yacho pasi pesimba uye usakanganwa kuronga kutumirwa nezuva rakatarwa. Uye pakupedzisira, kana zuva rekutumira richienderana nenhasi, saka iwe unofanirwa kudonhedza zvese uye kubata neiri batch panguva ino (yepamusoro pekutanga).
Kuti ujekese, iwe unogona kuseta matatu ane zvirevo zvekufometa mitemo kuti uzadze otomatiki mutsara wese nebatch data mune akasiyana mavara zvichienderana nezuva rekutumira. Kuti uite izvi, sarudza tafura yose (isina musoro) uye sarudza pane tab Kumba – Conditional Formatting – Gadzira Rule (Kumba - Conditional Formatting - Gadzira Rule). Mufafitera rinovhurwa, isa rudzi rwekupedzisira rwemutemo Shandisa fomula kuti uone kuti ndeapi maseru ekufomatidza (Shandisa fomula kuona kuti sero ripi refomati) uye isa inotevera fomula mumunda:
Formula iyi inotora zviri mukati memasero E5, E6, E7… munhevedzano kubva pachikamu chemazuva echikepe uye inoenzanisa zuva iroro neranhasi muchitokisi C2. Kana zuva rekutumira riri mberi kupfuura nhasi, saka kutumira kwakatoitika. Cherechedza zviratidzo zvedhora zvinoshandiswa kusungirira zvinongedzo. Chirevo che $ C $ 2 chinofanira kunge chakakwana - nezviratidzo zvemadhora maviri. Chirevo chesero yekutanga yekoramu ine zuva rekutumira inofanira kuva nekugadzirisa chete mbiru, asi kwete mutsara, kureva $E5.
Mushure mekupinda fomula, unogona kuseta iyo yekuzadza uye font color nekudzvanya bhatani Framework (Format) wobva washandisa mutemo wedu nekudzvanya pabhatani OK. Wobva wadzokorora maitiro ese kuti utarise kuendesa uye kutumirwa kwezuva razvino. Kune mabheti akatumirwa, semuenzaniso, unogona kusarudza grey, yeramangwana maodha - girini, uye yanhasi - yekukurumidzira tsvuku:
Panzvimbo yezuva razvino, unogona kuisa basa racho muchitokisi C2 TODAY (NHASI), iyo inovandudza zuva nguva imwe neimwe iyo faira inovhurwa, iyo inozogadzirisa otomatiki mavara ari patafura.
Kana kujekesa kwakadaro kusingadi nguva dzose, asi kune imwe nguva yekushanda netafura, ipapo unogona kuwedzera rudzi rwekuchinja kune zvakatoitwa. Kuti uite izvi, vhura iyo tab yokuvaka (Mugadziri). Kana isingaonekwe, saka tanga wabatidza Faira - Sarudzo - Gadzirisa Ribhoni Uye chengetedza Insert (Isa):
Mune rondedzero yezvishandiso zvinovhura, sarudza Checkbox (Checkbox) kubva kumusoro seti Zvidzoreso zvemafomu wobva wadzvanya panzvimbo papepa paunoda kuriisa. Ipapo iwe unogona kuseta saizi yechinyorwa uye wochinja iwo mavara (tinya-kurudyi - Chinja mavara):
Zvino, kuti ushandise bhokisi rekutarisa kuti ubatidze kana kudzima chinovhenekera, unofanirwa kuchibatanidza kune chero sero pane pepa. Tinya-kurudyi pabhokisi rekutarisa rakadhonzwa uye sarudza rairo kubva pane yemukati menyu Object Format (Format Object) uye ipapo pahwindo rinovhurwa, isa chero sero yakakodzera mumunda Kutaurirana kwesero (Sero Link):
Tarisa kuti zvese zvinoshanda sei. Yakabatanidzwa sero E2 inofanira kubuda CHOKWADI kana bhokisi rekutarisa rabatidzwa, kana kuti FALSE kana ravharwa.
Ikozvino chasara kuwedzera mutemo mumwechete kune inomisikidzwa fomati kuitira kuti bhokisi redu rekutarisa ritendeuke zuva rekuvhenekera nekudzima. Sarudza tafura yedu yese (kunze kweiyo musoro) uye vhura iyo mu tab Musha — Conditional Formatting — Manage Rules (Kumba - Conditional Formatting - Manage Rules). Muhwindo rinovhurika, iyo mitemo yatakagadzira kare yekunongedza misi yakapfuura, yeramangwana uye yazvino mumavara akasiyana inofanira kuoneka zvakajeka:
Dhinda bhatani Gadzira Rule (Mutemo Mutsva), sarudza rudzi rwekupedzisira rwekutonga Shandisa fomula kuti uone kuti ndeapi maseru ekufomatidza (Shandisa fomula kuona kuti sero ripi refomati) uye isa inotevera fomula mumunda:
Isu hatiseti iyo fomati uye tinya OK. Mutemo wakasikwa unofanirwa kuwedzerwa kune general list. Iye zvino iwe unofanirwa kuisimudza kumutsara wekutanga nemiseve (kana isati yavepo) uye vhura bhokisi rekutarisa rakatarisana nayo kurudyi. Mira kana ichokwadi (Mira kana Chokwadi):
Parameter ine zita risingazivikanwe Mira kana ichokwadi inoita chinhu chakareruka: kana mutemo wainopikisa uri wechokwadi (kureva mureza wedu Kuratidzira nguva pabepa rakadzimwa), ipapo Microsoft Excel inomira kuenderera mberi kwekugadzirisa kwemitemo, kureva kuti haifambire mberi kune inotevera mitemo mune inomisikidzwa fomati runyorwa uye haina mafashama tafura. Zvinova ndizvo zvinodiwa.
- Conditional fomati muExcel 2007-2013 (vhidhiyo)
- Mbizi mitsetse yetafura mitsetse
- Iyo Excel inoshanda sei nemazuva uye nguva