Txoj kev formatting greyed tawm hauv Excel feem ntau yog vim tias phau ntawv ua haujlwm yog phau ntawv qhia ua haujlwm. Txhawm rau txheeb xyuas seb koj puas muaj cov ntawv qhia ua haujlwm sib koom ua haujlwm, mus rau REVIEW tab thiab nyem lub pob SHARE WORKBOOK.
Vim li cas Excel cell formatting greyed tawm?
Thaum cov haujlwm uas koj tab tom sim ua hauv daim ntawv ua haujlwm siv rautiv thaiv ntawm tes lossis daim ntawv, koj yuav pom cov zaub mov greyed-tawm. Koj yuav tsum tsis txhob tiv thaiv phau ntawv ua haujlwm, daim ntawv ua haujlwm lossis lub xov tooj ntawm tes kom qhib cov ntawv qhia tsis muaj. Nyem qhov "Home" ntawv qhia zaub mov, ces xaiv "Format" nyob rau hauv lub "Cells" tab.
Kuv yuav ua li cas thiaj ua tau raws li kev cai?
Conditional Formatting
- Xaiv qhov ntau A1:A10.
- Ntawm lub Tsev tab, nyob rau hauv pab pawg Styles, nyem Conditional Formatting.
- Click Highlight Cells Cov Cai, Ntau dua.
- Nkag mus rau tus nqi 80 thiab xaiv tus qauv tsim.
- Click OK. Kev tshwm sim. Excel qhia txog cov hlwb uas ntau dua 80.
- Hloov tus nqi ntawm tes A1 rau 81.
Kuv yuav ua li cas thiaj qhib qhov kev cai formatting hauv Excel?
Koj tuaj yeem tshem tawm Conditional Formatting tau yooj yim txhua lub sijhawm: Excel 2007 thiab tom qab ntawd: Xaiv Conditional Formatting los ntawm Lub Tsev tab, click Clear Rules, thiab tom qab ntawd tshem Cov Cai ntawm Tag Nrho Cov Ntawv.
Koj ua li cas thaum lub hom phiaj tsis ua haujlwm?
Conditional Formatting tsis ua haujlwm raug nrog cov ntaub ntawv…
- Xaiv tag nrhocov kab nrog cov ntaub ntawv (Kem A mus txog N).
- Home tab > Conditional Formatting > Txoj Cai Tshiab > kev xaiv "Siv tus qauv los txiav txim seb lub cell twg los ua qauv".
- hauv qab "Format values where this formula is true", enter=$K2="Y"
