Daga cikin daidaitattun kayan aikin Microsoft Excel, akwai hanyoyi daban-daban don haskaka kwafi tare da launi. Hanya mafi sauƙi kuma mafi sauri ita ce tare da tsara yanayin. Don yin wannan, kawai zaɓi kewayon sel kuma zaɓi kan shafin Gida - Tsarin Yanayi - Dokokin Zaɓin Cell - Kwafin Dabi'u (Gida - Tsarin Yanayi - Haskaka Dokokin Kwayoyin - Ƙimar Kwafi):
Duk da haka, a wannan yanayin, cikar launi na dukkan sel zai kasance iri ɗaya, watau kawai yana nuna alamar cewa kashi yana da kwafi a wani wuri a cikin kewayon, amma ba ya yin wani abu don taimakawa gano su. Kuna iya gyara halin da ake ciki tare da ƙaramin macro wanda zai cika kowane biyu (ko fiye) na maimaitawa tare da launi nasa:
Don haka yafi bayyana, dama? Tabbas, tare da adadi mai yawa na ƙwayoyin maimaitawa, zai zama da wahala a rarrabe tsakanin inuwa, amma tare da ƙaramin adadin kwafi, wannan hanyar zata yi aiki daidai.
Don amfani da wannan macro, danna gajeriyar hanyar madannai Alt+F11 ko button Kayayyakin aikin Basic tab developer, Saka sabon tsarin komai ta hanyar menu Saka - Module kuma kwafi code na wannan macro a can:
Sub DuplicatesColoring() Dim Dupes()'Bayyana tsararru don adana kwafin Dupes ReDim(1 Zuwa Selection.Cells.Count, 1 Zuwa 2) Selection.Interior.ColorIndex = -4142 'Cire cika idan i = 3 Ga Kowane tantanin halitta A ciki Zaɓi Idan WorksheetFunction.CountIf(Zaɓi, cell.Value)> 1 Sannan Don k = LBound(Dupes) Zuwa UBound(Dupes) 'idan tantanin halitta ya riga ya kasance cikin tsararrun kwafi, cika Idan Dupes(k, 1) = cell Sai cell.Interior. ColorIndex = Dupes(k, 2) Na gaba k 'idan tantanin halitta ya ƙunshi kwafi, amma bai riga ya shiga cikin tsararru ba, ƙara shi a cikin tsararru kuma cika shi Idan cell.Interior.ColorIndex = -4142 Sai cell.Interior.ColorIndex = i Dupes(i, 1) = cell.Value Dupes(i, 2) = ii = i + 1 Ƙarshe Idan Ƙarshen Ƙarshen tantanin halitta na gaba
Yanzu zaku iya zaɓar kowane kewayon tare da bayanai akan takardar kuma gudanar da macro ɗin mu ta amfani da gajeriyar hanyar keyboard Alt+F8 ko ta hanyar maballin Macros (Macros) tab developer (Mai haɓakawa).
- Hana kwafi tare da launi
- Menene macros, inda za a saka macro code a cikin Visual Basic, yadda ake gudanar da su
- Yadda ake ƙirga adadin ƙima na musamman a cikin kewayon sel