Phakathi kwamathuluzi ajwayelekile e-Microsoft Excel, kunezindlela eziningi ezahlukene zokugqamisa izimpinda ngombala. Indlela elula neshesha kakhulu ingokufometha okunemibandela. Ukuze wenze lokhu, vele ukhethe uhla lwamaseli bese ukhetha kuthebhu Ikhaya — Ukufometha Okunemibandela — Imithetho Yokukhetha Amaseli — Amanani Aphindeke kabili (Ikhaya — Ukufometha Okunemibandela — Gqamisa Imithetho Yamaseli — Amanani Ayimpinda):
Kodwa-ke, kulesi simo, umbala wokugcwalisa wawo wonke amaseli uzofana, okusho ukuthi imane ibonise ukuthi isici sinezimpinda kwenye indawo kububanzi, kodwa ayenzi lutho ukusiza ukuwathola. Ungalungisa isimo nge-macro encane ezogcwalisa ipheya ngalinye (noma ngaphezulu) lokuphindaphinda kabili ngombala walo:
Kucace kakhulu, akunjalo? Yiqiniso, ngenani elikhulu lamaseli aphindaphindiwe, kuyoba nzima ukuhlukanisa phakathi kwe-shades, kodwa ngenani elincane lokuphindaphinda, le ndlela izosebenza ngokuphelele.
Ukuze usebenzise le makhro, cindezela isinqamuleli sekhibhodi I-Alt + F11 noma inkinobho Visual Basic ithebhu Unjiniyela, faka imojuli entsha engenalutho ngemenyu Faka – Imojula bese ukopisha ikhodi yale macro lapho:
I-Sub DuplicatesColoring() I-Dim Dupes() 'Memezela uhlu oluzogcina izimpinda ze-ReDim Dupes(1 To Selection.Cells.Count, 1 To 2) Selection.Interior.ColorIndex = -4142 'Susa ukugcwaliswa uma i = 3 Ngeseli Ngalinye Ukukhetha Uma I-WorksheetFunction.CountIf(Ukukhethwa, iseli.Value) > 1 Bese Kwe k = LBound(Dupes) Ukuze UBUund(Dupes) 'uma iseli selivele likuhlu lwezimpinda, gcwalisa Uma Dupes(k, 1) = cell Bese cell.Interior. ColorIndex = Dupes(k, 2) Okulandelayo k 'uma iseli liqukethe impinda, kodwa lingakabikho ohlelweni, lingeze kumalungu afanayo bese uligcwalisa Uma iseli.Interior.ColorIndex = -4142 Bese kuthi cell.Interior.ColorIndex = i I-Dupes(i, 1 ) = iseli.I-Value Dupes(i, 2) = ii = i + 1 Qeda Uma Iphela Uma Iseli Elandelayo End Sub Sub
Manje ungakhetha noma yibuphi ububanzi obunedatha eshidini futhi usebenzise i-macro yethu usebenzisa isinqamuleli sekhibhodi I-Alt + F8 noma ngokusebenzisa inkinobho amamakhro (Amakhrosi) ithebhu Unjiniyela (Unjiniyela).
- Gqamisa izimpinda ngombala
- Ayini ama-macros, lapho ungafaka khona ikhodi ye-macro ku-Visual Basic, ukuthi ungayisebenzisa kanjani
- Ungabala kanjani inani lamanani ahlukile ebangeni elinikeziwe lamaseli