Yuav Paub
- Desktop: Xaiv cov xov tooj ntawm tes > Format > Conditional Formatting. Nkag mus rau cov kev cai ntawm cov qauv, qauv, thiab hom hom, tom qab ntawd xaiv Done.
- Android: Xaiv xov tooj ntau > Format > Tsim txoj cai > Conditional Formatting. Nkag mus rau cov cai, cov qauv, hom qauv. Xaiv Txuag.
- Delete ib txoj cai: Hover tus cursor hla txoj cai thiab xaiv lub trash can icon (desktop) los yog coj mus rhaub lub trash can icon (mobile).
Txoj kev formatting hauv Google Sheets tso cai rau koj ntxiv qhov kev tshaj lij rau koj cov ntawv nthuav tawm los ntawm kev hloov kho qhov zoo thiab kev xav ntawm cov hlwb, kab, lossis kab raws li qee yam kev cai, lossis nrhiav cov ntaub ntawv tshwj xeeb los qhia cov duplicates. Nov yog yuav ua li cas thiaj li siv tau cov kev cai formatting hauv Google Sheets ntawm lub computer lossis Andriod ntaus ntawv.
Yuav ua li cas Siv Conditional Formatting ntawm lub Desktop Browser
Conditional formatting txhais tau hais tias thaum cov xwm txheej tshwj xeeb tau ntsib, keeb kwm yav dhau thiab cov ntawv xim hauv Google Sheets cov hlwb hloov tam sim ntawd. Qhov no muaj txiaj ntsig zoo thaum koj xav pom qee cov ntaub ntawv lossis hu tawm cov ntaub ntawv tshwj xeeb.
Ntawm no yog li cas cov kev cai formatting ua haujlwm rau Google nplooj ntawv ntawm Windows PC lossis Mac siv Chrome, Firefox, Safari rau Mac, lossis IE 11 thiab Edge rau Windows.
Google Sheets tuaj yeem ua haujlwm hauv lwm qhov browsers, tab sis txhua qhov nta yuav tsis muaj.
-
Xaiv lub xovtooj ntawm qhov chaw koj xav thov kev hloov kho raws cai.
piv txwv no siv daim ntawv nthuav qhia nrog cov neeg muag khoom tus nqi hloov pauv.
-
Xaiv Format los ntawm cov ntawv qhia zaub mov saum toj kawg nkaus.
Image -
Select Conditional Formatting.
Image - The Txoj cai hom ntawv dialog box tshwm nyob rau sab xis ntawm qhov screen.
-
Xaiv lub Hloov cov hlwb yog cov ntawv qhia zaub mov poob thiab xaiv qhov xwm txheej. Yog koj ua raws li qhov piv txwv no, xaiv Less than.
Image Xaiv los ntawm ntau yam kev piav qhia tus kheej, lossis xaiv Custom los tsim ib qho xwm txheej.
- In the Value or formula box, nkag mus rau qhov xwm txheej. Piv txwv li no, nkag mus rau 30% txhawm rau qhia cov neeg muag khoom uas nws qhov kev hloov pauv tsawg dua 30%.
-
Nyob hauv Formatting style, xaiv cov xim keeb kwm yav dhau los lossis xaiv hom kev caixaiv xim thiab cuam tshuam, suav nrog bold thiab italics.
Image -
Txhawm rau txhim kho qhov xwm txheej ntxiv, xaiv qhov Xim Scale tab.
Image -
Xaiv qhov gradient. Cov xim ntawm sab laug siv rau tus lej qis dua hauv cov xov tooj ntawm tes uas tau xaiv. Cov xim ntawm sab xis cuam tshuam cov nqi siab dua.
Koj yuav pom qhov saib ua ntej ntawm cov xim gradient thaum koj xaiv xim nplai.
-
Thaum koj zoo siab nrog koj cov kev xaiv xaiv hom, xaiv Done. Daim ntawv nthuav qhia qhia txog koj qhov chaw.
Image Txhawm rau siv ntau yam kev hloov pauv rau tib lub xov tooj ntawm tes, mus rau Format > Conditional Formatting, thiab xaiv Ntxiv lwm txoj cai Google Sheets ua ntau txoj cai hauv qhov tseem ceeb ntawm sab saum toj mus rau hauv qab. Hloov cov cai los ntawm kev rub txoj cai nce lossis nqis hauv daim ntawv teev npe.
Yuav ua li cas siv cov xwm txheej formatting ntawm Android ntaus ntawv
Ntawm no yog li cas formatting ua haujlwm rau Google Sheets ntawm Android ntaus ntawv.
- Tua tawm Google Sheets app thiab qhib ib daim ntawv tshiab lossis uas twb muaj lawm.
- Xaiv lub xov tooj ntawm tes uas koj xav kom format.
- Caws lub Format khawm, sawv cev los ntawm tsab ntawv A, ze rau sab saum toj ntawm daim ntawv nthuav qhia.
- Koj yuav pom Tsim txoj cai interface. Scroll cia thiab xaiv Conditional Formatting.
- Xaiv lub Format cells yog cov ntawv qhia zaub mov poob thiab xaiv qhov xwm txheej.
- Kho cov duab koj xav siv rau cov hlwb uas ua tau raws li koj tus mob. Hauv ntu Formatting style, coj mus rhaub ib qho ntawm rau qhov kev xaiv lossis xaiv Custom xaiv xim thiab cuam tshuam.
- Coj mus rhaub rau Xim nplai tab txhawm rau siv cov xim gradient rau cov hlwb. Xaiv tus naj npawb thiab xim koj xav siv.
-
Tap Txuag siv koj cov kev xaiv. Koj yuav pom koj txoj cai tshiab ntawm Conditional Formatting npo. Coj mus rhaub lub check mark kom tawm thiab rov qab mus rau daim ntawv nthuav dav.
Tap Txuag thiab Tshiab txhawm rau ntxiv lwm txoj cai.
Yuav siv cov qauv kev cai li cas
Google Sheets muab ntau tshaj li kaum ob lub hom phiaj xwm txheej cuam tshuam nrog cov kab ntawv, hnub tim, thiab tus lej muaj nuj nqis. Koj tsis txwv rau cov kev xaiv no. Siv cov qauv kev cai los siv cov xwm txheej rau lub xov tooj ntawm tes raws li qhov tseem ceeb ntawm lwm lub hlwb, uas tsis yog ib qho kev xaiv nrog cov kev xaiv ua ntej.
piv txwv no siv cov qauv kev cai los qhia thaum tus nqi tib yam tshwm sim hauv ntau dua ib lub xov tooj siv COUNTIF muaj nuj nqi.
-
Qhib ib daim ntawv nthuav qhia thiab xaiv lub xov tooj ntawm tes uas koj xav ua hom ntawv. Qhov piv txwv no xaiv cov hlwb B2 txog B15.
Image - Go to Format > Conditional Formatting.
-
Under Format cells if, xaiv Custom formula is.
Image -
Sau cov mis rau hauv Vim lossis Formula teb. Piv txwv li no, siv tus qauv:
=COUNTIF(B:B, B2)>1
Yog tias koj lub cell tsis nyob hauv kab B, hloov nws rau koj kem, thiab hloov B2 mus rau thawj lub xovtooj ntawm koj xaiv ntau yam.
-
Xaiv Done. Txhua cov ntaub ntawv sib tshooj hauv koj daim ntawv nthuav qhia tau qhia.
Image
Yuav ua li cas tshem tawm cov xwm txheej formatting ntawm lub Desktop Browser
Nws yooj yim tshem tawm txoj cai formatting.
-
Xaiv lub xov tooj ntawm tes uas koj xav tshem tawm ib lossis ntau qhov kev cai formatting.
Image -
Xaiv Format.
Image -
Choose Conditional Formatting.
Image - Koj yuav pom cov cai tswj hwm kev hloov pauv tam sim no. Txhawm rau rho tawm txoj cai, txav tus cursor hla txoj cai thiab xaiv trash can icon.
Yuav ua li cas tshem tawm cov xwm txheej formatting ntawm lub cuab yeej Android
- Xaiv lub xovtooj lossis cov xovtooj uas koj xav tshem tawm ib lossis ntau qhov kev cai formatting.
- Tap Format (ua sawv cev los ntawm tsab ntawv A).
- Xaiv Conditional Formatting.
- Koj yuav pom cov npe ntawm cov cai tam sim no. Txhawm rau tshem tawm txoj cai, coj mus rhaub khib nyiabicon nyob ib sab ntawm nws.
