Ide: Lòt lang yo se Google-tradui. Ou ka vizite a English vèsyon nan lyen sa a.
Ouvri yon sesyon
x
or
x
x
enskri
x

or

Bòt Excel ou a ak yon kostim Excel
300 + pwofesyonèl ak fasil-itilize zouti pou Excel 2019-2003

adapte 1adapte 2adapte 3adapte 4

Ki jan yo koulè kode gout desann lis nan Excel?

doc-koulè-gout-desann-lis1
Nan Excel, kreye yon gout desann lis ka ede w yon anpil, epi pafwa, ou bezwen koulè kode gout la desann valè lis depann sou korespondan a chwazi. Pou egzanp, mwen te kreye yon gout desann lis non fwi a, lè mwen chwazi Apple, mwen bezwen selil la ki gen koulè wouj otomatikman, epi lè mwen chwazi Orange, ka selil la gen koulè ak zoranj kòm D 'sa yo montre. Èske gen nenpòt sijesyon bon rezoud sa a?
Koulè kode gout desann lis ak kondisyonèl fòma

flèch ble jarèt dwat Koulè kode gout desann lis ak kondisyonèl fòma

Pou fini travay sa a, nou bezwen kreye yon gout desann lis premye, ak Lè sa a, aplike fòma nan kondisyonèl nan koulè selil yo. Tanpri fè etap sa yo:

Premyèman, kreye yon gout desann lis:

1. Kreye yon lis done epi chwazi yon seri ke ou vle mete gout desann valè lis la. Nan ka sa a, mwen chwazi kolòn A yo mete gout la desann lis, al gade Ekran:

doc-koulè-gout-desann-lis1

2. Klike sou Done > Done Validasyon > Done Validasyon, gade D:

doc-koulè-gout-desann-lis1

3. Ak nan la Done Validasyon bwat dyalòg, klike sou Anviwònman tab, epi chwazi Lis opsyon soti nan la Pèmèt gout desann lis, epi klike sou doc-bouton-1 bouton pou yo chwazi valè lis ke ou vle itilize. Al gade nan Ekran:

doc-koulè-gout-desann-lis1

4. Lè sa a, klike sou OK, yo te gout desann lis la kòm sa yo montre:

doc-koulè-gout-desann-lis1

Dezyèmman, aplike fòma nan kondisyonèl nan koulè kode gout la desann valè lis

5. Mete aksan sou gout ou desann selil (isit la se kolòn A), epi ale nan klike sou Akèy > Kondisyonèl fòma > Nouvo Règleman, gade D:

doc-koulè-gout-desann-lis1

6. Nan Nouvo Règ fòmatif bwat dyalòg, klike sou fòma selil sèlman ki gen opsyon nan la Chwazi yon kalite Règleman seksyon, anba a Fòma sèlman selil ak seksyon, chwazi Espesifik Tèks soti nan gout nan premye desann lis epi chwazi ki gen soti nan gout nan dezyèm desann, Lè sa a, klike sou doc-bouton-1bouton yo chwazi valè a ke ou vle fòma yon koulè espesifik, al gade Ekran:

doc-koulè-gout-desann-lis1

7. Lè sa a, klike sou fòma bouton, epi chwazi yon koulè ou renmen nan la Ranpli tab.
doc-koulè-gout-desann-lis1

8. Lè sa a, klike sou OK > OK yo fèmen dyalòg yo, etap repete 5 pou 7 pou chak lòt gout desann seleksyon, pou egzanp, Pèch pou vèt, rezen pou koulè wouj violèt ...

9. Apre mete koulè yo pou valè yo, lè ou chwazi nenpòt ki valè de gout desann meni an, selil la ap gen koulè ak koulè espesifik li yo otomatikman.

doc-koulè-gout-desann-lis1

Si ou vle konte / sòm oswa fè kalkil pa koulè selilè / font koulè, ou ka eseye sa a:

Byen vit konte / selil sòm pa background oswa koulè fomt nan Excel

Nan kèk ka, ou ka gen yon seri de selil ki gen koulè miltip, ak sa ou vle se konte / sòm valè ki baze sou menm koulè, ki jan ou ka byen vit kalkile?
avèk Kutools pou Excel's Konte pa Koulè, ou ka byen vit fè anpil kalkil pa koulè, epi tou li ka jenere yon rapò sou rezilta a kalkile. Klike pou gratis jijman konplè tap nan jou 60!
doc konte pa koulè 1
Kutools pou Excel: ak plis pase 300 sou la meni Excel ajoute-ins, gratis eseye ki pa gen okenn limit nan jou 60.

Tabbed Navigasyon & koreksyon plizyè liv Excel / Dokiman Pawòl kòm Firefox, Chrome, Entènèt Eksplore 10!

Ou ka abitye wè paj miltip nan Firefox / Chrome / IE, ak chanje ant yo pa klike sou onglè korespondan fasil. Isit la, Biwo Tab sipòte pwosesis menm jan an, ki pèmèt ou browse plizyè miltip Excel oswa dokiman Pawòl nan yon fenèt Excel oswa fenèt Pawòl, epi fasil chanje ant yo pa klike sou onglè yo. Klike pou gratis jijman 45-jou nan Biwo Tab!

ekselan


Rekòmande Zouti Productivity

Biwo Tab

lò star1 Pote onglè sou lamen pou Excel ak lòt biwo lojisyèl, jis tankou Chrome, Firefox ak nouvo Internet Explorer.

Kutools pou Excel

lò star1 Etonan! Ogmante pwodiktivite ou nan minit 5. Pa bezwen okenn ladrès espesyal, sove de zè de tan chak jou!

lò star1 300 karakteristik nouvo pou Excel, fè Excel anpil fasil ak pwisan:

  • Rantre selilè / ranje / Kolòn san yo pa pèdi done.
  • Konbine ak Konsolide Pliye Plizyè ak Manyèl.
  • Konpare Range, Kopi plizyè chif, Konvèti tèks nan dat, inite ak konvèsyon lajan.
  • Konte pa Koulè, Paging subtotals, Avanse Triye ak Super Filter,
  • Plis Chwazi / Insert / Efase / Tèks / Fòma / Link / Kòmantè / Workbooks / Worksheets Zouti ...

Piki ekran nan Kutools pou Excel

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    PM · 10 months ago
    thanks for the really good help
  • To post as a guest, your comment is unpublished.
    oli · 1 years ago
    Hi, this was very helpful. However, now i need to color the whole line in the same color in reference to one cell on the line. know what i mean? can you assist in this too?

    thanks again!
    • To post as a guest, your comment is unpublished.
      Sunny · 1 years ago
      Try this: in step 5, Highlight your drop down cells(here is column A) is replace with highlight the whole lines where place your drop down list cells, then apply the conditional formatting rule.
  • To post as a guest, your comment is unpublished.
    Tonf · 1 years ago
    Thank you ! It worked perfectly for me
  • To post as a guest, your comment is unpublished.
    eds · 1 years ago
    well, finally it works!
    this article should have been informed about the Excel version. Format Conditioning has its new feature in Excel 2013 and above and has quite a little different.
    For example, the step above as mentioned would only work if your MS Excel you are using is version 2010 and above. For below, the reason why it wouldn't worked is because conditioning format should be placed the value on the containing cell i.e you have to type the word apple to the rule (and not $D$2 as stated in the screenshot). The reason why some others had come up a not working is maybe because it use up different version of MS Excel like mine which is MS Excel 2007.

    the value should have been like this upon filing up in Format only cells Specific Text:
    Specific Text - Containing - type the word Apple or grapes or strawberry. Then,
    Go to Format button for your specified color and fonts you desire.

    As for me, you don't need to have select the entire cells in spreadsheet as it would only gotten confuse.
  • To post as a guest, your comment is unpublished.
    Lauren · 1 years ago
    Very helpful tutorial! Much appreciated!