Conditional Formatting hauv Excel

Conditional formatting nyob rau hauv Excel cia li hloov cov tsos ntawm ib tug cell raws li nws cov ntsiab lus. Piv txwv li, koj tuaj yeem pom cov cell liab uas muaj qhov tsis raug. Zaj lus qhia no yuav tsom mus rau kev hloov kho raws li txoj cai, ib qho ntawm cov cuab yeej zoo tshaj plaws thiab muaj txiaj ntsig hauv Excel.

Xav txog tias koj muaj ib daim ntawv Excel uas muaj ib txhiab kab ntawm cov ntaub ntawv. Kuv xav tias nws yuav nyuaj heev ntawm tag nrho cov ntaub ntawv no kom pom cov qauv lossis cov ntaub ntawv tsim nyog. Zoo li cov kab kos thiab cov kab hluav taws xob, kev ua raws li kev cai pab koj pom cov ntaub ntawv thiab ua kom yooj yim nyeem.

To taub qhov xwm txheej Formatting

Conditional formatting nyob rau hauv Excel cia koj cia li format hlwb raws li qhov tseem ceeb uas lawv muaj. Txhawm rau ua qhov no, koj yuav tsum tsim cov kev cai formatting. Txoj cai yuav zoo li no: "Yog tias tus nqi qis dua $ 2000, cov xim ntawm tes yog liab." Siv txoj cai no, koj tuaj yeem txheeb xyuas cov cell uas muaj nuj nqis tsawg dua $ 2000.

Tsim txoj cai formatting raws cai

Hauv qhov piv txwv hauv qab no, daim ntawv ua haujlwm Excel muaj cov ntaub ntawv muag khoom rau 4 lub hlis dhau los. Cia peb hais tias peb xav paub cov neeg muag khoom twg tau ntsib lawv lub hom phiaj muag txhua hli thiab qhov twg tsis yog. Txhawm rau ua kom tiav cov phiaj xwm, koj yuav tsum tau muag ntau dua $ 4000 toj ib hlis. Cia peb tsim ib txoj cai formatting uas yuav xaiv tag nrho cov hlwb hauv lub rooj nrog tus nqi ntau dua $4000.

1. Xaiv cov hlwb uas koj xav kuaj. Hauv peb qhov xwm txheej, qhov no yog qhov ntau B2: E9.
2. Hauv Advanced tab Tsev nias hais kom ua Kev Ntsuas Ntawm Tus Qauv. Ib tug dropdown zaub mov yuav tshwm.
3. Xaiv txoj cai xav formatting txoj cai. Peb xav qhia cov hlwb uas nws muaj nuj nqis Ntau info $ 4000.
4. Ib lub dialog box yuav tshwm sim. Sau tus nqi yuav tsum tau. Hauv peb qhov xwm txheej, qhov no 4000.
5. Qhia kom meej ib tug formatting style los ntawm cov npe drop-down. Peb yuav xaiv Ntsuab sau thiab tsaus ntsuab ntawv nyeem… Ces nias OK.
6. Cov kev cai formatting yuav siv tau rau cov cell xaiv. Tam sim no koj tuaj yeem pom tau yooj yim cov neeg muag khoom tau ua tiav cov phiaj xwm txhua hli ntawm $ 4000.

Koj tuaj yeem siv ntau txoj cai formatting rau tib lub hlwb ib zaug, uas tso cai rau koj hloov pauv ntau dua thiab pom cov ntaub ntawv koj xav tau.

Tshem tawm cov kev cai formatting

1. Push command Kev Ntsuas Ntawm Tus Qauv. Ib tug dropdown zaub mov yuav tshwm.
2. Txav tus nas pointer hla qhov khoom Rho tawm Cov Cai thiab xaiv cov cai uas koj xav tshem tawm. Hauv peb qhov piv txwv, peb yuav xaiv Tshem tawm cov cai ntawm tag nrho daim ntawvtshem tawm tag nrho cov xwm txheej formatting ntawm daim ntawv ua haujlwm.
3. Cov kev cai formatting yuav raug tshem tawm.

Koj tuaj yeem xaiv yam khoom Txoj cai tswjkom pom tag nrho cov kev cai formatting tsim nyob rau hauv daim ntawv no los yog hauv kev xaiv. Tus Txheej Txheem Formatting Rules Manager tso cai rau koj los kho lossis tshem tawm cov cai kev cai. Qhov no yog qhov tshwj xeeb tshaj yog tias koj tau tsim ntau txoj cai ntawm tib daim ntawv.

Preset Conditional Formatting Styles

Excel los nrog cov txheej txheem ua ntej uas koj tuaj yeem siv tau sai sai rau kev hloov kho rau koj cov ntaub ntawv. Lawv muab faib ua peb pawg:

1. Гcov histograms yog cov kab kab rov tav ntxiv rau txhua lub xov tooj ntawm tes hauv daim ntawv teev cov kab ntawv.
2. Xim nplai hloov cov xim ntawm txhua lub xov tooj raws li lawv qhov muaj nuj nqis. Txhua xim nplai siv ob lossis peb xim gradient. Piv txwv li, nyob rau hauv cov xim liab-daj-ntsuab xim nplai, qhov siab tshaj plaws qhov tseem ceeb yog qhov tseem ceeb hauv xim liab, qhov nruab nrab qhov tseem ceeb nyob rau hauv daj, thiab qhov tsawg kawg nkaus qhov tseem ceeb nyob rau hauv ntsuab.
3. Icon teebs ntxiv cov cim tshwj xeeb rau txhua lub xov tooj raws li lawv cov txiaj ntsig.

Siv preset styles

1. Xaiv cov cell los tsim txoj cai formatting.
2. Push command Kev Ntsuas Ntawm Tus Qauv. Ib tug dropdown zaub mov yuav tshwm.
3. Hover koj tus nas hla cov qeb uas xav tau, thiab tom qab ntawd xaiv qhov preset style.
4. Cov kev cai formatting yuav siv tau rau cov cell xaiv.