01 ye 01
Excel Shading Rows / Columns Formula
Kazhinji nguva, maitiro akashandurwa anoshandiswa kuchinja sero kana mavara mavara mukutarisa kune data yakapinda muchitokisi sezuva rakapera kana mari yekushandisa mari yakakwirira kwazvo, uye kazhinji izvi zvinoshandiswa kuburikidza nekushandura kweEexcel.
Mukuwedzera kune zvakasarudzwa kusarudzwa, zvisinei, zvinogonawo kugadzira mitemo yakagadziriswa yemasikirwo emitemo uchishandisa Excel mazano kuti uongorore zvinoshandiswa nevashandisi-zvataurwa.
Chimwe chimiro chakadai chinosanganisira MOD uye ROW mabasa, chinogona kushandiswa kuti chinyatsove mumvuri mamwe maitiro e data angaita kuti kuverenga dhesi mumashizha makuru ebasa , nyore nyore.
Shading Dynamic
Rimwe ruzivo kushandisa shanduro yekuwedzera mutsara wekugarisa ndeyekuti shading inoshandiswa iyo inoreva kuti inoshanduka kana nhamba yemirasi ichichinja.
Kana mitsetse ichiiswa kana kusunurwa shading yemutsara inozvigadzirisa pachayo kuitira kuti igadzire chimiro.
Cherechedza: Mimwe mikana haisiyo chete inosarudzwa neyuyu fomu. Nokurichinja zvishoma, sezvakakurukurwa pasi apa, chimiro chacho chinogona kuve mumvuri chero ipi zvayo yemigwagwa. Iyo inogona kushandiswa kumumvuri mikoko panzvimbo yemigwagwa kana iwe ukasarudza.
Muenzaniso: Shading Rows Formula
Nhanho yekutanga ndeyekutarisa huwandu hwemasero kuti huve shaded kubva apo chimiro chinongogadzirisa masero aya akasarudzwa.
- Vhura Excel worksheet-pepa rekushanda risina chinhu richashandira iyi tutori
- Simbisa mhando dzemasero mubasa rekushanda
- Dzvanya paImba yebhu yebhoni
- Dzvanya pamufananidzo weChimiro Chekugadziridza pane kuti uzarure menyu inoderera
- Sarudza Mutsva Rule chisarudzo chekuti uzarure Ikushandura Maitiro Rute rekushandisa dialog box
- Dzvanya paKushandisa Chirafu kuti uone kuti masero chii kuenzanisa sarudzo kubva pane urongwa uri pamusoro pebhokisi rebhokisi
- Chengetedza maitiro aya anotevera mubhokisi riri pasi apa Mafomu ekufambisa apo ichi chinokosha chiri chechokwadi pane imwe muzasi yebhokisi yebhokisi = MOD (ROW (), 2) = 0
- Dzvanya bhiiyo Fomu kuti uzarure maBhokisi eDaiti maBhokisi
- Dzadza Futa tabo kuti uone ruvara rwemaruva emushure
- Sarudza muvara waunoshandisa kuti uve shave mimwe mizere yezera rakasarudzwa
- Dzvanya OK kechipiri kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda
- Mimwe mizere yakasarudzwa yakatarwa inofanira kuve yakasvibiswa nemusarudzo wakasarudzwa
Kududzira Mutemo
Maitiro aya aya anoverengwa neExcel ndeokuti:
- nhamba yechipiri mumusarudzo inoratidza kuti shading pattern inodzokorora mutsara wega wega wega mumusarudzo yakasarudzwa
- mamiriro ezvinhu = 0 mumutsetse unogadzira kuti mutsara wokutanga uri mumakero hauna shaded - zvinoitwa nokuti iyi rutsara inowanzo ine misoro ine maitiro ayo.
Iko MOD uye ROW Ita
Iyo muenzaniso inobva pane MOD inoshandiswa mumutambo. Chinoitwa MOD chinoparadzanisa nhamba yemutsara (yakagadzirirwa neROW basa) nenhamba yechipiri mukati mezvigaro uye inodzorera yakasara kana modulus sezvainowanzonzi dzimwe nguva.
Parizvino, kuumbwa kwemagariro kunotora uye kuenzanisa modulus nenhamba mushure mokunge chiratidzo chakaenzana. Kana pane chiitiko (kana zvakanyanya zvakakodzera kana mamiriro acho ari ECHOKWADI), mutsetse wacho wakafuridzirwa, kana nhamba kumativi ose echiratidzo chakaenzana haafananidzi, mamiriro acho ari FALSE uye hapana shading inowanikwa mumutsara iwoyo.
Somuenzaniso, mumufananidzo wepamusoro, apo mutsara wokupedzisira mumasara akasarudzwa 18 akaparadzaniswa ne 2 neMOD basa, zvasara ndeye 0, saka mamiriro e 0 = 0 ndeechokwadi, uye rutsanga rwuri shaded.
Row 17, kune rumwe rutivi, kana yakapatsanurwa ne2 inosara imwe yakasara ye1, iyo isingaenzani 0, saka iro rutsara rinosara risina kukwana.
Shading Columns Panzvimbo Yemakumbo
Sezvakataurwa, maitiro anoshandiswa mumvuri mamwe maitiro anogona kuchinjwa kuti abvumira shading columns zvakare. Kuchinja kunofanirwa kushandisa kushandisa COLUMN pane basa reROW mumutambo. Mukuita kudaro, maitiro acho aizotarisa seizvi:
= MOD (COLUMN (), 2) = 0Cherechedza: Kuchinja kumigwagwa ye shading yekuchinja maratiro emu shading anotsanangurwa pasi apa kunoshandawo kumusasa we shading.
Shandura Fomu, Shandisa Shading Pattern
Kuchinja shave pattern kunonyatsoitwa kuburikidza nekuchinja kana imwe yenhamba mbiri mumutsetse.
- Kuti uve nemumvuri wemutsara unotanga nemutsara wokutanga pane wechipiri, pamagumo echinyorwa, shanduka = 0 kusvika = 1 ;
- Kuti uve nemutsara wechitatu kana wechina shaded panzvimbo yemimwe mizere, shandura 2 mumutambo we 3 kana 4.
Kuparadzanisa hakugone kuva Zero kana Imwe
Nhamba iri mukati mabheji inonzi " divisor" sezvo iri nhamba iyo inoparadzanisa mubasa reMOD. Kana iwe uchiyeuka kumashure mune zvidzidzo zvemasvomhu zvakaparadzana ne zero hazvina kubvumirwa uye hazvibvumirwi mu Excel kana. Kana iwe uchiedza kushandisa zero mukati memabhazi panzvimbo ye2, zvakadai se:
= MOD (ROW (), 0) = 2iwe hauzovi nekunyunyutika zvachose mumutambo.
Zvimwewo, kana iwe uchiedza kushandisa nhamba imwe yemudzidzisi kuitira kuti chimiro chinoratidzika se:
= MOD (ROW (), 1) = 0mutsara mumwe nomumwe uri mumutsetse uchadzikiswa. Izvi zvinowanzoitika nokuti nhamba ipi neipi yakakamurwa neimwe inosara imwe yakasara ye zero, uye yeuka, kana mamiriro e 0 = 0 ari ECHOKWADI, mutsetse unozununguswa.
Shandisa Operator, Shandisa Shading Pattern
Kuti uchinje zvakare chimiro, shandura chirevo chemukati kana chekuenzanisa (chiratidzo chakaenzana) chinoshandiswa mumutsara kusvika pasi pechiratidzo (<).
Nokushandura = 0 kusvika <2 (pasi pe2) semuenzaniso, mizere miviri pamwe chete inogona kushandiswa. Ita izvozvo <3, uye shading ichaitwa mumapoka emitsara mitatu.
Iyo chete yevhavha yekushandisa pasi peasingatengi ndeyekuti uone kuti nhamba mukati memakakani yakakura kudarika nhamba pamagumo emutambo. Kana zvisingaiti, mutsara wega wega uri mumuganhu uchadzikiswa.