Skip to main content

Conas stailc uathoibríoch a dhéanamh bunaithe ar luach cille in Excel?

In Excel, is féidir linn an stailc a chur i bhfeidhm chun an t-ábhar cille nach dteastaíonn a bhaint de láimh, ach, san Airteagal seo, labhróidh mé faoi conas dul ar stailc uathoibríoch bunaithe ar luach cille. Mar shampla, ba mhaith liom stailc tríd a chur i bhfeidhm do shonraí na rónna bunaithe ar an luach cille i gColún E, más é “N” an luach cille, chun an líne tríd a chur i bhfeidhm go huathoibríoch do na sraitheanna coibhneasta mar a thaispeántar an scáileán seo a leanas.

stailc uathoibríoch 1 doc

Stailc tríd an gcarr bunaithe ar luach cille le Formáidiú Coinníollach


mboilgeog cheart gorm saighead Stailc tríd an gcarr bunaithe ar luach cille le Formáidiú Coinníollach

Go deimhin, ar an Formáidiú Coinníollach Is féidir le gné in Excel cabhrú leat an tasc seo a chríochnú chomh tapa agus is féidir, déan mar seo le do thoil:

1. Roghnaigh an raon sonraí a theastaíonn uait chun an stailc tríd, agus ansin cliceáil Baile > Formáidiú Coinníollach > Riail Nua, féach ar an scáileán:

stailc uathoibríoch 2 doc

2. Sa an Riail Nua Formáidithe bosca dialóige, cliceáil le do thoil Úsáid foirmle chun a fháil amach cé na cealla atá le formáidiú rogha sa Roghnaigh Cineál Riail bosca liosta, agus ansin cuir isteach an fhoirmle seo: =$E2="N" isteach sa Luachanna formáide nuair atá an fhoirmle seo fíor bosca téacs, féach an pictiúr:

Nóta: San fhoirmle thuas: E2 agus "N” an luach cille agus téacs a bhfuil tú ag iarraidh stailc tríd a chur i bhfeidhm bunaithe air, le do thoil iad a athrú chuig do riachtanas.

stailc uathoibríoch 3 doc

3. Agus ansin cliceáil déanta cnaipe chun dul go dtí an Cealla Formáid dialóg, faoin Cló tab, seiceáil Strikethrough ó na Éifeachtaí bosca liosta, féach an scáileán:

stailc uathoibríoch 4 doc

4. Ansin cliceáil OK > OK chun na dialóga a dhúnadh, agus anois, nuair is é an téacs sonrach “N” an luach iontráilte atá agat, cuirfear na sonraí sraithe ar fad i bhfeidhm go huathoibríoch, féach an seat scáileáin:

stailc uathoibríoch 5 doc

Uirlisí Táirgiúlachta Oifige is Fearr

🤖 Kutools AI Aide: anailís sonraí a réabhlóidiú bunaithe ar: Forghníomhú Chliste   |  Gin Cód  |  Cruthaigh Foirmlí Saincheaptha  |  Anailís a dhéanamh ar Sonraí agus Cairteacha a Ghin  |  Feidhmeanna Kutools a agairt...
Gnéithe Coitianta: Faigh, Aibhsigh nó Aithnigh Dúblaigh   |  Scrios Sraitheanna Bána   |  Comhcheangail Colúin nó Cealla gan Sonraí a Chailleadh   |   Babhta gan Foirmle ...
Cuardaigh Super: Ilchritéir VLookup    VLookup Illuachanna  |   VLookup Trasna Ilbhileoga   |   Amharc doiléir ....
Liosta anuas Casta: Go tapa Cruthaigh Liosta Anuas   |  Liosta anuas Cleithiúnach   |  Liosta Buail Isteach Ilroghnacha ....
Bainisteoir Colún: Cuir Líon Sonrach Colún leis  |  Colúin Bog  |  Scoránaigh Stádas Infheictheachta na gColún Ceilte  |  Déan comparáid idir Raonta & Colúin ...
Gnéithe Réadmhaoin: Fócas Eangaí   |  Amharc Dearaidh   |   Barra Mór na Foirmle    Leabhar Oibre & Bainisteoir Bileog   |  Leabharlann Acmhainní (Uaththéacs)   |  Piocálaí Dáta   |  Comhcheangail Bileoga Oibre   |  Criptigh/Díchriptigh Cealla    Seol Ríomhphost trí Liosta   |  Scagaire Super   |   Scagaire Speisialta (scagaire trom/iodálach/stailc tríd...) ...
Barr 15 Uirlisí12 Téacs uirlisí (Cuir Téacs, Bain Carachtair,...)   |   50 + Cairt cineálacha (Cairt Gantt,...)   |   40+ Praiticiúil Foirmlí (Ríomh aois bunaithe ar lá breithe,...)   |   19 Insertion uirlisí (Cuir isteach Cód QR, Ionsáigh Pictiúr ón gCosán,...)   |   12 Tiontú uirlisí (Uimhreacha le Focail, Comhshó Airgeadra,...)   |   7 Cumaisc & Scoilt uirlisí (Sraitheanna Comhcheangail Casta, Cealla Scoilt,...)   |   ... agus eile

Supercharge Do Scileanna Excel le Kutools le haghaidh Excel, agus Éifeachtúlacht Taithí Cosúil Ná Roimhe. Kutools le haghaidh Excel Tairiscintí Níos mó ná 300 Ardghnéithe chun Táirgiúlacht a Treisiú agus Sábháil Am.  Cliceáil anseo chun an ghné is mó a theastaíonn uait a fháil ...

Tuairisc


Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
Comments (8)
Rated 5 out of 5 · 1 ratings
This comment was minimized by the moderator on the site
Hi,
How can I do if I want the row struckthrough if say EITHER B2= Yes OR I2 = 0?
If I just put it as OR($B2="Yes",$I2="0"), it wont strikethrough if both values are met.
Rated 5 out of 5
This comment was minimized by the moderator on the site
Is it possible to use this formula with a numeric value of zero? I cannot for the life of me get it to work that way but it will work with letters.
This comment was minimized by the moderator on the site
Hello friend,

Glad to help. Yes, you can use this formula =$E1= 0 with a numeric value of zero. Please see the screenshot, you can input formula =$E1= 0 into the Format values where this formula is true text box. Please note the first row of the data is header.
https://www.extendoffice.com/images/stories/comments/comment-zmt/strikethrough-value.png

Sincerely,
Mandy
This comment was minimized by the moderator on the site
Merci beaucoup :) <3 
This comment was minimized by the moderator on the site
I regularly wind up utilizing the strikethrough highlight in both Word and Excel to stamp things as finished. This component is genuinely clear in Word, as a strikethrough symbol shows up conspicuously on the Home tab in Word 2007 and later. Then again, in Excel this component doesn't have its own particular symbol, yet it has a console alternate route, Ctrl-5. However there's no worked in essay writing route for strikethrough in Word.
This comment was minimized by the moderator on the site
Hello everyone, I just have to say that this site is just amazing!
Much creative and extremely curricular website I have ever found while searching essay writing service on the Internet.
I am very satisfied with their work and inventory, everything looked very well and kept. I appreciate your work, keep up a great job.
This comment was minimized by the moderator on the site
This was a great help to me
This comment was minimized by the moderator on the site
Using the instructions from this page (Auto strikethrough based on cell value with Conditional Formatting) I am trying to add the proper formula to a spreadsheet with the cell value being a check mark (instead of N like the example). Ultimately, what I am trying to do is this: When I double click column A1, it will automatically add a check mark in that cell. In addition to the check mark, it will perform auto-strikethrough on cells B1 and C1. Is it possible to accomplish this? I had no problem entering a rule to add a check mark to a cell by double clicking it. And I had no problem adding the conditional formatting in order to auto strikethrough text. What I cannot seem to figure out is how to combine the 2 efforts. I do not like the idea of Check boxes and have tried that route already.
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations