Note: The other languages of the website are Google-translated. Back to English
Inloggen  \/ 
x
or
x
Registreer  \/ 
x

or

Hoe cellen tellen of optellen op basis van de lettertypekleuren in Excel?

Hoe kunt u het aantal cellen krijgen of alle cellen met een bepaalde letterkleur in Excel optellen? Ik heb bijvoorbeeld een gegevensbereik in een werkblad zoals in het volgende screenshot wordt getoond, en nu wil ik respectievelijk de cellen tellen of optellen met een rode, blauwe en zwarte lettertypekleur. Normaal gesproken is er geen directe manier om met deze taak om te gaan, hier zal ik het hebben over enkele trucs voor het oplossen van deze taak.

Tel of som cellen op basis van lettertypekleuren met door de gebruiker gedefinieerde functie

Tel of som cellen op basis van lettertypekleur met enkele handige functies

Tel of tel cellen op op basis van lettertypekleur met een geweldige functie - Tel op kleur


Tel of som cellen op basis van lettertypekleuren met door de gebruiker gedefinieerde functie

Tel cellen op basis van lettertypekleuren:

Ga als volgt te werk om het aantal cellen met specifieke lettertypekleuren te berekenen:

1. Houd de ALT + F11 toetsen, en het opent de Microsoft Visual Basic for Applications-venster.

2. Klikken Invoegen > Moduleen plak de volgende code in het Module Venster.

VBA-code: tel cellen op basis van lettertypekleuren:

Public Function CountColour(pRange1 As Range, pRange2 As Range) As Double
'Update by Extendoffice
Application.Volatile
Dim rng As Range
For Each rng In pRange1
    If rng.Font.Color = pRange2.Font.Color Then
        CountColour = CountColour + 1
    End If
Next
End Function

3. Sla deze code vervolgens op, ga terug naar het werkblad en voer deze formule in een lege cel in = CountColour (A1: D10, A2) , zie screenshot:

Opmerking:: In de bovenstaande formule, A1: D10 is het bereik dat u wilt gebruiken en A2 is de cel met een bepaalde lettertypekleur die u wilt tellen.

4. Druk na het typen van de formule op Enter key, en je krijgt het aantal cellen met rode lettertypekleuren. Als u andere cellen met lettertypekleur wilt tellen, voert u de formule zo vaak mogelijk in. U krijgt de volgende resultaten:


Somcellen op basis van lettertypekleuren:

Om cellen op te tellen op basis van lettertypekleuren, kan de volgende door de gebruiker gedefinieerde functie u helpen.

1. Houd de ALT + F11 toetsen, en het opent de Microsoft Visual Basic for Applications-venster.

2. Klikken Invoegen > Moduleen plak de volgende code in het Module Venster.

VBA-code: somcellen op basis van lettertypekleuren:

Public Function SumByColor(pRange1 As Range, pRange2 As Range) As Double
'Update by Extendoffice
Application.Volatile
Dim rng As Range
Dim xTotal As Double
xTotal = 0
For Each rng In pRange1
    If rng.Font.Color = pRange2.Font.Color Then
        xTotal = xTotal + rng.Value
    End If
Next
SumByColor = xTotal
End Function

3. Sla deze code vervolgens op en keer terug naar het oorspronkelijke werkblad, en voer vervolgens deze formule in = SumByColor (A1: D8; A1) in een lege cel, zie screenshot:

Opmerking:: In de bovenstaande formule, A1: D10 is het bereik dat u wilt gebruiken en A2 is de cel met een bepaalde lettertypekleur die u wilt optellen.

4. Druk vervolgens op Enter key, en u telt alle cellen op met rode lettertypekleuren. Als u andere cellen in lettertypekleur wilt optellen, voert u de formule herhaaldelijk in. U krijgt het volgende resultaat:


Tel of som cellen op basis van lettertypekleur met enkele handige functies

Het kan zijn dat de door de gebruiker gedefinieerde functie lastig voor je is om op te slaan en toe te passen, hier zal ik je een handig hulpmiddel aanbevelen-Kutools for Excel, met zijn geavanceerde functies, kunt u deze taak snel en gemakkelijk oplossen.

Tips:Om dit toe te passen COUNTBYFONTKLEUR als SUMBYLETTERKLEUR functies, ten eerste moet u het Kutools for Excelen pas de functie vervolgens snel en gemakkelijk toe.

Na het installeren van Kutools for Excel, doe dit als volgt:

Tel cellen op basis van lettertypekleuren:

1. Klik op een cel waar u het telresultaat wilt plaatsen en klik vervolgens op Kutools > Kutools-functies > Statistisch en wiskundig > COUNTBYFONTKLEUR, zie screenshot:

2. In de Functieargumenten dialoogvenster, specificeer het gegevensbereik en de kleurindexcel die u op lettertypekleur wilt tellen, zie screenshot:

3. En klik dan OK knop, krijgt u het eerste telresultaat, om andere resultaten te krijgen, hoeft u alleen deze formule te kopiëren en de celverwijzingen naar uw behoefte te wijzigen. Zie screenshot:


Somcellen op basis van lettertypekleuren:

1. Klik op een cel waar u het telresultaat wilt plaatsen en klik vervolgens op Kutools > Kutools-functies > Statistisch en wiskundig > SUMBYLETTERKLEUR, zie screenshot:

2. In de Functieargumenten dialoogvenster, specificeer het gegevensbereik en de kleurindexcel die u op lettertypekleur wilt optellen, zie screenshot:

3. En klik dan OK knop, u krijgt het resultaat van de eerste som, om andere resultaten te krijgen, hoeft u alleen deze formule te kopiëren en de celverwijzingen naar uw behoefte te wijzigen. Zie screenshot:

Klik om Kutools voor Excel en nu gratis uit te proberen!


Tel of tel cellen op op basis van lettertypekleur met een geweldige functie - Tel op kleur

Kutools for Excel biedt ook een gemakkelijke functie- Tel op kleurMet dit hulpprogramma kunt u snel het berekeningsresultaat zoals aantal, som, gemiddelde cellen enzovoort krijgen door de achtergrondkleur, lettertypekleur, voorwaardelijke opmaak naar behoefte.

Tips:Om dit toe te passen Tel op kleur -functie, ten eerste moet u de Kutools for Excelen pas de functie vervolgens snel en gemakkelijk toe.

Na het installeren van Kutools for Excel, doe dit als volgt:

1. Selecteer het gegevensbereik dat u wilt tellen en optellen op basis van verschillende kleuren.

2. Klikken Kutools Plus> Tel op kleur, zie screenshot:

3. In de Tel op kleur dialoogvenster, kies Standaardopmaak van de Kleur methode drop-down en selecteer doopvont onder de Type telling drop-down, en de cellen met dezelfde lettertypekleuren zijn geteld, opgeteld, gemiddeld enzovoort, zie screenshot:

4. En klik vervolgens op Genereer rapport knop, krijg je de statistieken in een nieuwe werkmap. Zie screenshot:

Klik om Kutools voor Excel en nu gratis uit te proberen!


Meer artikelen:

  • Tel en som cellen op basis van achtergrondkleur in Excel
  • Stel dat je een reeks cellen hebt met verschillende achtergrondkleuren, zoals rood, groen, blauw enzovoort, maar nu moet je tellen hoeveel cellen in dat bereik een bepaalde achtergrondkleur hebben en de gekleurde cellen met dezelfde bepaalde kleur optellen . In Excel is er geen directe formule om de som en het aantal kleurcellen te berekenen, hier zal ik u enkele manieren voorstellen om dit probleem op te lossen.
  • Tel / tel vetgedrukte cijfers in een reeks cellen in Excel
  • Als u een gegevensbereik heeft dat enkele vetgedrukte getallen in een werkblad bevat en u nu alleen de vetgedrukte cellen wilt optellen of tellen, kunt u ze natuurlijk een voor een handmatig optellen, maar dit zal tijdrovend zijn. Hoe kunt u op een gemakkelijke en snelle manier alleen de vetgedrukte cellen in Excel optellen of tellen?
  • Pas kleurverloop toe op meerdere cellen
  • In Excel kunnen we eenvoudig de achtergrondkleur in een cel of meerdere cellen vullen, maar soms hebben we het kleurverloop nodig zoals in het onderstaande screenshot, hoe kan het kleurverloop in een cel of over meerdere cellen in Excel worden verkregen?
  • Voeg celkolommen samen en behoud de tekstkleur in Excel
  • Zoals we allemaal weten, gaat bij het aaneenschakelen of combineren van celkolommen in één kolom de celopmaak (zoals tekstkleur, nummeropmaak, enz.) Verloren. In dit artikel zal ik enkele trucs introduceren om de celkolommen in één te combineren en de tekstkleur zo gemakkelijk mogelijk in Excel te behouden.
  • Tel of som cellen op basis van celkleur in Google-spreadsheet
  • Celwaarden tellen of optellen op basis van een specifieke celachtergrondkleur om het resultaat te krijgen zoals in het volgende screenshot. In dit artikel zal ik het hebben over het oplossen van deze taak in Google-spreadsheet en Microsoft Excel.

Cellen tellen of optellen op basis van lettertype / achtergrond / voorwaardelijke opmaakkleur:

Kutools for Excel: met meer dan 300 handige Excel-invoegtoepassingen, gratis te proberen zonder beperking in 30 dagen. Download en probeer nu gratis!

De beste tools voor kantoorproductiviteit

Kutools voor Excel lost de meeste van uw problemen op en verhoogt uw productiviteit met 80%

  • visfuik: Snel invoegen complexe formules, grafieken en alles wat je eerder hebt gebruikt; Versleutel cellen met wachtwoord; Maak een mailinglijst en stuur e-mails ...
  • Super Formula-balk (bewerk eenvoudig meerdere regels tekst en formule); Lay-out lezen (gemakkelijk grote aantallen cellen lezen en bewerken); Plakken in gefilterd bereik...
  • Voeg cellen / rijen / kolommen samen zonder gegevens te verliezen; Gespleten cellen inhoud; Combineer dubbele rijen / kolommen... Voorkom dubbele cellen; Vergelijk Ranges...
  • Selecteer Dupliceren of Uniek Rijen; Selecteer lege rijen (alle cellen zijn leeg); Super zoeken en fuzzy zoeken in veel werkboeken; Willekeurige selectie ...
  • Exacte kopie Meerdere cellen zonder de formuleverwijzing te wijzigen; Maak automatisch verwijzingen naar meerdere bladen; Plaats kogels, Selectievakjes en meer ...
  • Extraheer tekst, Tekst toevoegen, Verwijderen op positie, Ruimte verwijderen; Paging-subtotalen maken en afdrukken; Converteren tussen celinhoud en opmerkingen...
  • Super filter (bewaar en pas filterschema's toe op andere bladen); Geavanceerd sorteren per maand / week / dag, frequentie en meer; Speciaal filter door vet, cursief ...
  • Combineer werkmappen en werkbladen; Tabellen samenvoegen op basis van sleutelkolommen; Gegevens splitsen in meerdere bladen; Batch Converteer xls, xlsx en PDF...
  • Meer dan 300 krachtige functies. Ondersteunt Office / Excel 2007-2019 en 365. Ondersteunt alle talen. Eenvoudig te implementeren in uw onderneming of organisatie. Gratis proefperiode van 30 dagen met volledige functies. 60 dagen geld-terug-garantie.
kte tabblad 201905

Office-tabblad Brengt een interface met tabbladen naar Office en maakt uw werk veel gemakkelijker

  • Schakel bewerken en lezen met tabbladen in Word, Excel, PowerPoint in, Publisher, Access, Visio en Project.
  • Open en maak meerdere documenten in nieuwe tabbladen van hetzelfde venster in plaats van in nieuwe vensters.
  • Verhoogt uw productiviteit met 50% en vermindert elke dag honderden muisklikken voor u!
officetab onderkant
Say something here...
symbols left.
You are guest
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.
    Joseph · 1 years ago
    Hi..


    I used it to count and sum from matrix. The problem is that the I need to count/sum in multiple range of cells. Is it possible to update this code to do this?
    • To post as a guest, your comment is unpublished.
      skyyang · 1 years ago
      Hello, Joseph,

      Maybe there is no direct way for you to count or sum the cell values based on font color in multiple ranges, but, you can apply the third method in this article and use Count by Color feature of Kutools for Excel, with this feature, you just need to select the multiple ranges first, and then apply the feature.
      https://www.extendoffice.com/documents/excel/1418-excel-count-sum-by-font-color.html#a3

      Please try it, thank you!
  • To post as a guest, your comment is unpublished.
    me · 2 years ago
    COUNT CELLS BY FONT COLOR tutorial was great! But it is not working when the font color was based on the conditional formatting. Do you have something for this concern?
    • To post as a guest, your comment is unpublished.
      skyyang · 1 years ago
      Hello,
      The codes in this article can not support the conditional formatting, but, you can use our Kutools for Excel's Count by Color feature, it can help you to count or sum conditional font colors. Please try it.
  • To post as a guest, your comment is unpublished.
    Sarah · 2 years ago
    This was exactly what I needed - Thanks!
  • To post as a guest, your comment is unpublished.
    ISMERCIO · 2 years ago
    = SumByColor (A1: D8, A1) NÃO FUNCIONOU


    =SumByColor(A1:D8;A1) FUNCIONOU

    TIRANDO ESPAÇO E USANDO " ; " AO INVÉS DE " , " AI FUNCIONOU LEGAL.

    USO EXCEL 10


    MUITO BOM.


    OBRIGADO

  • To post as a guest, your comment is unpublished.
    Borja · 2 years ago
    Is there a way to change Count Or Sum Cells Based On Font Colors With User Defined Function into count or sum cells based on de conditional formating?

    I've tried with

    Public Function CountColour(pRange1 As Range, pRange2 As Range) As Double

    Application.Volatile
    Dim rng As Range
    For Each rng In pRange1

    If rng.FormatConditions.Font.Color = pRange2.FormatConditions.Font.Color Then
    CountColour = CountColour + 1

    End If
    Next
    End Function

    But it appears not to work, any suggestion?
    Thanks
    • To post as a guest, your comment is unpublished.
      skyyang · 2 years ago
      Hello, Borja,
      May be you can use our product, Kutools for Excel, with its Count by Color feature, you can quickly count or sum the cell values based on the conditional formatting without any VBA code, please try. You can download it and free trial in 60 day.
      Thank you!
  • To post as a guest, your comment is unpublished.
    exhtee@gmail.com · 2 years ago
    I tried the SumByColor. It works, but not if the numbers have been coloured by conditional formatting. For example, I have a list of different numbers that are coloured red if they are within a range set by a conditional formatting rule. I would then like to sum only the red-coloured numbers. But the SumByColor VBA code does not work in this situation. Any suggestions to make it work. Thanks
    • To post as a guest, your comment is unpublished.
      skyyang · 2 years ago
      Hello, Xiahui,
      The above code can not applied to conditional formatting color, but, you can use our Kutools for Excel' Count by color feature, with it, you can quickly get the result for counting or summing based on the conditional formatting color. See the below screenshot:
  • To post as a guest, your comment is unpublished.
    Kriss · 2 years ago
    Hey
    Nice macro. I used it to just count from a simple matrix. The problem is that the macro counts also empty cells. How to exclude empty cells from counting?
    • To post as a guest, your comment is unpublished.
      skyyang · 2 years ago
      Hello, Kriss,
      To count the cells based on font color excluding the blank cells, please apply the below User Defined Function, please try:

      Public Function CountColour(pRange1 As Range, pRange2 As Range) As Double
      Application.Volatile
      Dim rng As Range
      For Each rng In pRange1
      If rng.Value <> "" Then
      If rng.Font.Color = pRange2.Font.Color Then
      CountColour = CountColour + 1
      End If
      End If
      Next
      End Function
  • To post as a guest, your comment is unpublished.
    Tahj · 2 years ago
    Exactly what I was looking for! This will save me lots of time. Thank You
  • To post as a guest, your comment is unpublished.
    Fernanda · 2 years ago
    Muito obrigada já ajudou muito, porém a minha formula só adiciona à soma outro número quando eu uso o pincel para mudar a cor, se eu trocar a cor da fonte pela barra de ferramenta não dá certo, alguém saber me explicar - webchio@gmail.com
  • To post as a guest, your comment is unpublished.
    Cheryl · 2 years ago
    This was SO helpful - Thanks very much!
  • To post as a guest, your comment is unpublished.
    Hien Dang · 3 years ago
    Hướng dẫn bên trên hình như chỉ áp dụng khi màu của giá trị trong ô hoặc màu nền của ô được tô màu bằng Manual.M muốn đếm số ô mà giá trị được bôi màu theo cách Conditional Formatting.Xin giúp đỡ ạ!
  • To post as a guest, your comment is unpublished.
    Gennelee · 3 years ago
    Hi I tried it but when I changed the color of other items, it doesnt add up or the sum doesnt change.
    Please help me.
  • To post as a guest, your comment is unpublished.
    JWong · 3 years ago
    Hi,

    I followed the instructions and it works well. But then when i re-open the file, the module window is empty. It seems i cannot save the code as needed. A box pops up saying that "VB project cannot be saved in macro-free workbooks" and therefore i have to save as a macro-free workbook.

    Please advise if I have missed any steps.

    Thanks,
    J. Wong
  • To post as a guest, your comment is unpublished.
    Adam · 3 years ago
    Rather than count or sum cells based on font colour, is there a way to display certain 'values' in another column based on font colour? for example, I have a column with multiple company names that each have a specific font colour to indicate a specific calendar year. I would like to simply create a 'year' column beside this. So for example if column B contains text with font colour green, this will display "2017" in column C. And if column B contains text with font colour red, this will display "2016" in column C. I dread to do this manually as I have thousands of rows!
  • To post as a guest, your comment is unpublished.
    antonella · 3 years ago
    Hi,
    I followed the instructions above for SumByColor and they worked great.
    I was wondering whether there is a similar formula in VB to sum by background color rather than using Kutools.
    thanks, Antonella
    • To post as a guest, your comment is unpublished.
      skyyang · 3 years ago
      Hi, Antonella,
      The VBA code in the following article may help you, please view it.
      https://www.extendoffice.com/documents/excel/1155-excel-count-sum-cells-by-color.html

      Hope it can help you!
      Thank you!
  • To post as a guest, your comment is unpublished.
    Mike · 4 years ago
    hi, your solution works well but when i change the content of a cell in the range to the colour selected the result cell doesn't auto update unless i go to the result cell select the formula and hit enter. Is there a way to auto update the result cell when the range is amended.
    • To post as a guest, your comment is unpublished.
      skyyang · 4 years ago
      Hello, Mike,
      May be there is no other good method to update the result automatically when you change the cell font color, so, you need selec t the formula cell and hit Enter key or click the Automatic under the Formulas tab to get the updated result.
      If you have any other good ways, please comment here.
      Thank you very much!
  • To post as a guest, your comment is unpublished.
    mfleming · 4 years ago
    I did everything as instructed by I get #VALUE! instead of a total. I changed the formula to subtotal one single cell and it worked but when the formula has a range of cells (in my case D3:D53, I get the #VALUE result.
  • To post as a guest, your comment is unpublished.
    dfmoeller · 4 years ago
    I can't seem to get past this syntax error that I am getting. I'm not very knowledgeable when it comes to visual basic, so I'm hoping that it is just a small typing error (although I did cut and paste the code from above, rather than retype). The machine is running Windows 10/Office 2013. The error says "compile error / syntax error". The VB windows shows the line with the IF statement in the SumByColor module as highlighted. Please tell me what I'm doing wrong.
  • To post as a guest, your comment is unpublished.
    Liz · 4 years ago
    I followed the instructions for SUMbyColor (for font).Showed up perfectly on my screen (my work pc has Excel 2010 ) however, on my boss's screen it comes up as '#NAME?' (fyi, his pc has the current Excel version).Is there any way to resolve this?
    • To post as a guest, your comment is unpublished.
      skyyang · 4 years ago
      [quote name="Liz"]I followed the instructions for SUMbyColor (for font).Showed up perfectly on my screen (my work pc has Excel 2010 ) however, on my boss's screen it comes up as '#NAME?' (fyi, his pc has the current Excel version).Is there any way to resolve this?[/quote]
      Hello,LIZ:
      After inserting the code, you should save the workbook as [b]Excel Macro-Enabled Workbook[/b] file format. And then when you open this Excel file next time, you should click[b] Enable Content[/b] from the security warning ribbon to activate the macro code. Please try this.
  • To post as a guest, your comment is unpublished.
    Luke · 4 years ago
    Hi tks for the advice.
    I have a similar problem of MYTAWALBEH
    I would like to include more columns in the function
    would be great if someone has some tips
    cheers
  • To post as a guest, your comment is unpublished.
    Smudge · 4 years ago
    Great read and working brilliant however is it possible for anyone to explain how I could apply this to a multiple set of sheets??

    Any idea will be much appreciated so cheers in advance.
  • To post as a guest, your comment is unpublished.
    Smudge · 4 years ago
    Great read and works awesome but could someone please tell me how to apply this to multiple sheets.

    If anyone can, this will be brilliant for what I need and will be much appreciated indeed.
  • To post as a guest, your comment is unpublished.
    Phillip · 4 years ago
    Is there any way to count the cells by colour without Kutools?
  • To post as a guest, your comment is unpublished.
    Nicola · 5 years ago
    Hi! Works great, thanks.

    However, doesnt work for cells with more than one colour. Is it possible to update this code to do this?

    Nikki
  • To post as a guest, your comment is unpublished.
    KH · 5 years ago
    How do I get the spread sheet to automatically update? If my data/color changes the sum doesn't update until I select the cell with the formula, hit F2, and then click off the cell. I want my sheet to automatically update as the data changes. Thanks.
  • To post as a guest, your comment is unpublished.
    atul gaur · 5 years ago
    Sir#name error aa rahi hai
  • To post as a guest, your comment is unpublished.
    Leanne · 5 years ago
    Hi

    I need to count the number of cells in orange font from cell range B:B if Cell Range AB says 'Ventura'

    The above allows you to count according to one criteria but doesn't allow a second - I have tried but I have never written macros before and cannot get this working. Urgent help needed please?

    Thank you
    Leanne
  • To post as a guest, your comment is unpublished.
    Diana · 6 years ago
    I followed your directions for the count but in the cells that I have =CountColour(...) I have the #NAME error. I have multiple tabs, so I put the code in the sheet where I want to use it but I still got the error, so then I put it in a module. What am I missing??
    • To post as a guest, your comment is unpublished.
      nada · 5 years ago
      Click the Microsoft Office Button , and then click Excel Options.
      Click Trust Center, click Trust Center Settings, and then click Macro Settings.
      Click the options to enable macro
  • To post as a guest, your comment is unpublished.
    gwenn · 6 years ago
    thank you very much... needed a little debugging but I think that's because nothing is ever cookie cutter, what I did to fix my issues may be different than what anyone else may need to do (based on version, etc.) but once I took out the rem'd line and made sure that I was pointing to the right fields and format field to do the comparison to, it worked like a charm.
  • To post as a guest, your comment is unpublished.
    Janna · 6 years ago
    the countcolor function includes the spaces between the cell that has that specific color. can you fix this?

    thanks alot!
  • To post as a guest, your comment is unpublished.
    magician1314 · 6 years ago
    MYTawalbeh,

    I had the same issue. You have to save the workbook as a macro enabled workbook so the macro copies over. Otherwise you will continue to have the error because the macro isn't being copied over.
  • To post as a guest, your comment is unpublished.
    MYTawalbeh · 6 years ago
    IT worked ,, thank you
    But when I save and close worksheet then re-open, it shows (#Name?)
    I've saved it (Macro-enabled)
    • To post as a guest, your comment is unpublished.
      Lisa · 4 years ago
      Click to enable macros on the yellow bar at the top of the page when you open your document and your formulas will come back. Hope this helps.
  • To post as a guest, your comment is unpublished.
    Stefanos N · 6 years ago
    Excellent work!

    Saved my wife's night!

    Thx
  • To post as a guest, your comment is unpublished.
    MEREDITH · 6 years ago
    Hello, I keep getting an error as follows "Ambiguous name detected: SumByColor". What am i doing wrong?
    • To post as a guest, your comment is unpublished.
      Lisa · 4 years ago
      I got this message when I tried to apply the same thing to another spreadsheet. When you go to insert module and copy in the text change it to SumByColour (different spelling and note there are two instances of it in the text). Then when I tried to use the formula in my second spreadsheet the new spelling came up which I selected and now the function works in this spreadsheet too. I hope this works for you because I am finding it extremely useful for various spreadsheets I work with.
  • To post as a guest, your comment is unpublished.
    Eddie L · 6 years ago
    I use a very similar method but have been playing with MULTI Colored fonts... say [Only the [b]BOLD[/b] word is red], fingers crossed you have a thought as to how I may achieve this!

    Cheers
    Eddie
  • To post as a guest, your comment is unpublished.
    nomnom · 6 years ago
    super cool, helped me a ton.

    if you don't mind me asking.
    when i try this on a colored cell number affected with "Conditional Formatting" it seems to see all the numbers as a single color. are there any way to have the program recognize that the color is different.
  • To post as a guest, your comment is unpublished.
    Khizar Hayat. · 7 years ago
    it works very good and so nice function.

    thank you.
  • To post as a guest, your comment is unpublished.
    Oguz Canturk · 7 years ago
    How do we do well to access?
  • To post as a guest, your comment is unpublished.
    Nick Roma · 7 years ago
    Hi,
    when i use this formula it keeps coming up with "Compile Error: Must be first statement on the line" and it has highlighted the "Function" on the first line of the formula. Help??
    • To post as a guest, your comment is unpublished.
      Suzy · 4 years ago
      May be you did not insert a module instead copied the code on the screen after Alt+F11
  • To post as a guest, your comment is unpublished.
    Minh Chau · 7 years ago
    Thank you so much! It works like wonder!