Conditional Formatting nyob rau hauv MS Excel - ib tug me ntsis-paub sab ntawm lub nrov spreadsheet

Cov tsev neeg ntawm chaw ua hauj lwm cov khoom ntawm Microsoft Corporation nyob rau hauv lub Excel lub npe yog ib tug series ntawm haib spreadsheet processors yog heev nrov ob dog dig tus kheej lub computer cov neeg siv thiab cov neeg ua hauj nqaim profile uas no haib txheej software cuab yeej muaj ntev los ua ib tug indispensable cuab tam nyob rau hauv lub chaw ua hauj lwm ntawm kev kawm txog lej, graphics , thiab lwm yam ntaub ntawv.

Qhov no software cov khoom no yog ib tug siv technology tsim kev ua loj cov ntaub ntawv poob lawm. Excel tso cai rau koj mus automate thiab kom meej meej formalize qhov kev siv ntawm ib tug ntau yam ntawm zoo xws li cov pawg, raws li zoo raws li yuav ua rau cov zauv hais txog zauv thiab ntseeg cuav thaum ub ntaub ntawv nyob rau hauv loj tagnrho.

Piv txwv li, ua ceev ceev, yog thiab npaum tsom xam txog nyiaj txiag, nyiaj khwv tau los them se, thiab lwm yam Ntsiab nta ntawm no haib software tau ntev tau zoo kawm los ntawm tag nrho cov neeg muaj feem. Tab sis Excel muaj ib tug ntau ntawm cov secrets thiab tricks paub xwb mus rau ib tug nqaim vajvoog ntawm cov kws tshwj xeeb. Ib tug ntawm cov tsis pub leejtwg paub ob tog yog nyob ntawm formatting. Qhov no muaj nuj nqi muaj ib tug heev ntau yam ntawm tej yam txawv nta.

Lub cuab tam, hu ua lub "zwj ceeb formatting" ua rau nws tau mus cuag tsis tshua muaj neeg interesting tau thiab ib tug stunning nrig txog kev pom tho txawv cov ntaub ntawv poob lawm. Cov tau siv no muaj nuj nqi yuav daws tau ntau yam teeb meem thiab yog heev ntau haiv neeg. Conditional formatting tso cai rau kom muaj tej yam cell hom raws li tus txheem thaum predetermined tej yam kev mob. Qhov no hom ntawm formatting yog yooj yim thiab tsis tshua muaj xav zoo nyob rau hauv cais loj cov ntaub ntawv poob lawm.

Conditional Formatting rau Excel, tsis muaj exaggeration, yog ib tug haib lub cuab tam uas opens unprecedented zeem muag kev ua hauj lwm nrog spreadsheets thiab cia rau ib tug tshiab saib lub array ntawm qhuav nuj nqis. Tshwj xeeb yog impressive no txawv txawv sij hawm los saib ntawm tag nrho cov hom kev nthuav qhia cov ntaub ntawv. Conditional hom ua nws yooj yim mus nrhiav tau ntau yam kev zam, distracting los ntawm lub zuag qhia tag nrho series cov ntaub ntawv. Tseem ceeb tiam sis kuj tsis ploj ntawm lub analyst tus saib. Qhov no yuav tsis tshua muaj neeg pab tau nyob rau hauv lub ua ntawm tej ntaub ntawv. Conditional Formatting nyob rau hauv Excel 2007 muaj ib co nthuav tshaj, xws li xim gradients, txawv shading cov ntaub ntawv kab, tshwj xeeb icons uas ntxiv rau lub hlwb thiab tso cai rau koj kom sai lw kev sib txuas lus nruab nrab ntawm cov ntau yam ntsuas.

Siv zwj ceeb formatting yog tseem heev yooj yim - cia li ib tug ob peb nas clicks. Wb hais tias koj tsim tau ib lub rooj nyob rau hauv tej yam hlwb uas muaj ib co tsis. Koj yuav tsum hloov lub cell sau xim nyob rau hauv raws li cov kev hloov ntawm suav cov ntaub ntawv tseem ceeb muaj nyob rau hauv lawv. Piv txwv li, yog hais tias tus cell muaj ib tug tsis zoo pes tsawg, nws yuav tau sau xim yog xim liab, thiab yog hais tias zoo - ntsuab.

Ua li no, cia li yuav tsum tau siv lub "Format" ntawv qhia zaub mov, nias qhov khoom nyob rau hauv uas lub "Conditional Formatting". Nyob rau hauv no cell, uas yog tsim nyog los muab cov kev kawm hom ntawv, nws yuav tsum tau tseem ceeb. Nyob rau hauv lub dialog box "Conditional Formatting" koj yuav tsum qhia kom meej rau mob nyob rau hauv uas lub cell thiab hloov cov xim ntawm koj sau. Nrog lub khawm "Format" ntawm lub tib lub dialog box los piav cov kev kawm tsos.

Yog hais tias koj yuav tau hloov lub formatting ntawm ib tug cell mus rau lwm lub, nyob ntawm seb cov ntaub ntawv, ces nws yog tsim nyog mus rau chaw uasi mus rau lub "mis" ntawm sab laug nco-down daim ntawv teev box zwj ceeb tawm tswv yim. Qhov kev ncua deb ntawm lub hlwb tsis txawv. Cov mis kuj yuav muaj: txawm tias muab xam rau ntawm statistical tseem ceeb, txawm hais tias tus nqi ntawm kev luv nqi ntawm cov cuab tam. Piv txwv li, yog tias koj xav mus, thaum lub cell A1 yog ib tug ntau yam ntawm plaub, cov kev ntawm tes los yog ntau hlwb nrhiav ib tug daj sau, ces, raws li ib tug mob, sau nram qab no mis: "= MOD (A1, 4) = 0." Ces siv lub "Format" khawm kom qhia kom meej rau qhov kev kawm sau xim. Ntxiv mus, los ntawm kev luam thiab pasting formatting yog pauv mus rau lub kev kawm ntawm tes los yog ntau yam.