Skip i'r prif gynnwys

Sut i ddefnyddio lliwiau neu ffontiau ffont lluosog mewn un cell yn Excel?

Mewn sawl achos, mae angen i chi ddefnyddio lliwiau neu ffontiau ffont lluosog i ragori ar rai geiriau penodol mewn un gell sengl. Mae'r erthygl hon yn dangos dau ddull i chi ei ddatrys yn fanwl.

Defnyddiwch liwiau neu ffontiau ffont lluosog mewn un cell yn Excel

Defnyddiwch liwiau neu ffontiau ffont lluosog mewn un cell yn Excel

Gallwch ddilyn y gweithrediadau isod i gymhwyso lliwiau neu ffontiau ffont lluosog mewn un cell.

1. Dewiswch y gell rydych chi am gymhwyso lliwiau neu ffontiau ffont lluosog, yna ewch i mewn i'r gell gan wasgu'r allwedd F2 (neu cliciwch ddwywaith ar y gell).

2. Dewiswch y testun sydd ei angen arnoch i ddefnyddio gwahanol liwiau ffont neu ffontiau, cliciwch Hafan > Lliw y Ffont or Ffont yn y Ffont grŵp, yna nodwch y lliw ffont neu'r ffont sydd ei angen arnoch chi. Gweler y screenshot:

3. Ailadroddwch y cam 2 nes bod y gell wedi'i llenwi â gwahanol liwiau ffont neu ffontiau sydd eu hangen arnoch chi.

Gallwch weld bod lliwiau ffont lluosog yn cael eu defnyddio mewn cell fel y dangosir isod.

Offer Cynhyrchiant Swyddfa Gorau

🤖 Kutools AI Aide: Chwyldro dadansoddi data yn seiliedig ar: Cyflawniad Deallus   |  Cynhyrchu Cod  |  Creu Fformiwlâu Personol  |  Dadansoddi Data a Chynhyrchu Siartiau  |  Invoke Swyddogaethau Kutools...
Nodweddion Poblogaidd: Darganfod, Amlygu neu Adnabod Dyblygiadau   |  Dileu Rhesi Gwag   |  Cyfuno Colofnau neu Gelloedd heb Colli Data   |   Rownd heb Fformiwla ...
Super-edrych: VLookup Meini Prawf Lluosog  |   VLookup Gwerth Lluosog  |   VLookup Ar Draws Taflenni Lluosog   |   Edrych Niwlog ....
Rhestr gwympo Uwch: Creu Rhestr Gollwng yn Gyflym   |  Rhestr Gollwng Dibynnol   |  Rhestr Gollwng Aml-ddewis ....
Rheolwr Colofn: Ychwanegu Nifer Penodol o Golofnau  |  Symud Colofnau  |  Toglo Statws Gwelededd Colofnau Cudd  |  Cymharwch Ystodau a Cholofnau ...
Nodweddion dan Sylw: Ffocws ar y Grid   |  Golwg Dylunio   |   Bar Fformiwla Mawr   |  Rheolwr Llyfr Gwaith a Thaflen   |  Llyfrgell Adnoddau (Testun Auto)   |  Dewiswr Dyddiad   |  Cyfuno Taflenni Gwaith   |  Amgryptio/Dadgryptio Celloedd   |  Anfon E-byst trwy Restr   |  Hidlo Super   |   Hidlo Arbennig (hidlo mewn print trwm/italig/strikethrough...) ...
15 Set Offer Gorau:  12 Testun offer (Ychwanegu Testun, Dileu Cymeriadau,...)   |   50 + Siart Mathau (Siart Gantt,...)   |   40+ Ymarferol Fformiwlâu (Cyfrifwch oedran yn seiliedig ar ben-blwydd,...)   |   19 mewnosod offer (Mewnosod Cod QR, Mewnosod Llun o'r Llwybr,...)   |   12 Trosi offer (Rhifau i Eiriau, Trosi arian cyfred,...)   |   7 Uno a Hollti offer (Rhesi Cyfuno Uwch, Celloedd Hollt,...)   |   ... a mwy

Supercharge Eich Sgiliau Excel gyda Kutools ar gyfer Excel, a Phrofiad Effeithlonrwydd Fel Erioed Erioed. Kutools ar gyfer Excel Yn Cynnig Dros 300 o Nodweddion Uwch i Hybu Cynhyrchiant ac Arbed Amser.  Cliciwch Yma i Gael Y Nodwedd Sydd Ei Angen Y Mwyaf...

Disgrifiad

Mae Office Tab yn dod â rhyngwyneb Tabbed i Office, ac yn Gwneud Eich Gwaith yn Haws o lawer

  • Galluogi golygu a darllen tabbed yn Word, Excel, PowerPoint, Cyhoeddwr, Mynediad, Visio a Phrosiect.
  • Agor a chreu dogfennau lluosog mewn tabiau newydd o'r un ffenestr, yn hytrach nag mewn ffenestri newydd.
  • Yn cynyddu eich cynhyrchiant 50%, ac yn lleihau cannoedd o gliciau llygoden i chi bob dydd!
Comments (12)
No ratings yet. Be the first to rate!
KARLA
KARLA
This comment was minimized by the moderator on the site
¿Como hago esto en el celular o ipad?
Reply
0
0
Luis
Luis
This comment was minimized by the moderator on the site
I have the same problem as SREEJITH UNNIMON. When I click outside the cell, everything gets to the initial color, ie, black!!
Reply
0
0
crystal
crystal     Luis
This comment was minimized by the moderator on the site
Hi Luis,
I'm not quite sure how this problem occurred. The font colors still exist when i click outside the cell. Do you mind attaching a screenshot or a sample file here?
Reply
Report
0
0
SREEJITH UNNIMON
SREEJITH UNNIMON
This comment was minimized by the moderator on the site
HEY!! BUT ALL THE FONTS ARE DISPLAYED AS BLACK WHEN I CLICK OFF THE CELL....CAN SOMEONE HELP??
Reply
0
0
Fanzi
Fanzi     SREEJITH UNNIMON
This comment was minimized by the moderator on the site
To see the adjusted color instead of the original black, ensure that the "Number Format" for the cell is set to "Text".
Reply
Report
0
0
paul
paul     Fanzi
This comment was minimized by the moderator on the site
this does not work if it is a date, set the cell to text, will change the date to some numbers.
Reply
0
0
natelawrence
natelawrence
This comment was minimized by the moderator on the site
Hi, friends,

Is it possible to achieve multiple font colors per cell based on conditional formatting?
If so, would you please explain how?

Thanks in advance for your answer.
Reply
Report
0
0
crystal
crystal     natelawrence
This comment was minimized by the moderator on the site
Hi,This cannot be done with conditional formatting.
Reply
Report
0
0
S
S
This comment was minimized by the moderator on the site
This isn't working for me. When i double click into a cell it won´t let me change color. Only for one cell at a time.
Reply
0
0
K Raj
K Raj
This comment was minimized by the moderator on the site
Utter non sense. Why would I select each character when I can simply select the whole word in excel and change the color or font. Tools are supposed to make life easier not to complex the things. I was wondering that I can do it easily with the help of tools. There are more than 5 thousand cells for which I need to make the changes. There are three lines in a single cell and each line has different color. Do you want to select each character in more than 5 thousand cells?
Reply
0
0
C Clair
C Clair     K Raj
This comment was minimized by the moderator on the site
You are an idiot. The purpose of this article is for when you want multiple font colors within a cell
Reply
0
0
Cassandra
Cassandra     C Clair
This comment was minimized by the moderator on the site
Don't call someone an idiot. That is ignorance within itself.
Reply
0
0
There are no comments posted here yet
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations