How To Count Cells By Colors With Conditional Formatting In Excel || How To Count Colored Cells




About this tutorial:

Video duration: 00:04:25
How To Count Cells By Colors With Conditional Formatting In Excel || How To Count Colored Cells

watch this video to understand how to How To Count Cells By Colors With Conditional Formatting In Excel

VBA code:

Sub DisplayColorCount()
Dim Rng As Range
Dim CountRange As Range
Dim ColorRange As Range
Dim xBackColor As Long
On Error Resume Next
xTitleId = “dptutorials”
Set CountRange = Application.Selection
Set CountRange = Application.InputBox(“Count Range :”, xTitleId, CountRange.Address, Type:=8)
Set ColorRange = Application.InputBox(“Color…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

13 thoughts on “How To Count Cells By Colors With Conditional Formatting In Excel || How To Count Colored Cells

    Madhuri Banoriya

    (July 13, 2020 - 10:42 pm)

    If i want the count in cell not in msgbox then how to do it.

    Prez13100

    (July 13, 2020 - 10:42 pm)

    I found this video on getting it into a cell. https://youtu.be/NflzVqndxW4

    Kral YouTube Oğuzhan Saraç

    (July 13, 2020 - 10:42 pm)

    This is the only video that I have found to count cells in conditional formatting, but can I place in a cell as a result?

    Jumbo Endurance

    (July 13, 2020 - 10:42 pm)

    Please do you have for Sum?

    QUINN DUNCIL

    (July 13, 2020 - 10:42 pm)

    Hi, can you make it not a macro but still work the same?
    If i do it for one row, i have to run it to all the rows, maybe i could just drag it down, something like that.
    Thanks anyway

    Fraser Sinclair

    (July 13, 2020 - 10:42 pm)

    This is a great tutorial. Is there a way to have the answer to the count appear as a number in a cell rather than in a pop-up window?

    Shravan Vashisht

    (July 13, 2020 - 10:42 pm)

    Hey, i tried doing the same. But its showing counts of all the cells i am selecting instead of giving counts of the color i choose. Will u please help me out in getting correct count

    Kinjal Bhatt

    (July 13, 2020 - 10:42 pm)

    Its the only method that worked for me. Thanks a lot.

    EL

    (July 13, 2020 - 10:42 pm)

    I didnt get the count .. can see the Macros only

    Manotejo

    (July 13, 2020 - 10:42 pm)

    Thank You! It was the only method that has worked for me.

    Sanjay Ghosal

    (July 13, 2020 - 10:42 pm)

    How to covert this SUB into a FUNCTION, where I can input Range-Cell & Cell (off rge Cell-Color) and get the output of the total counts.

    lexi zhao

    (July 13, 2020 - 10:42 pm)

    HI THERE, HOW CAN I SET U THE CRITERIA CELL? THANKS!

    Vane Esquivel

    (July 13, 2020 - 10:42 pm)

    Thanks for sharing! The VBA code is not within the description but I was able to transcribe it. When counting colors with conditional formatting, is it possible to have the result of the colored cells as data within the worksheet and not only in a pop-up window?

Leave a Reply

Your email address will not be published. Required fields are marked *