Ask Experts Questions for FREE Help !
Ask
    sriku24's Avatar
    sriku24 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jun 6, 2008, 12:38 AM
    How to count the cells in excel with different fill pattern styles
    Hi

    I want to count the cells in excel with different fill pattern styles.

    How is it possible. Can anyone post the function for this purpose like counting coloured cells.

    I tried a lot , but I got failed.

    Here I got a function to count cells filled solid, but it is not working... is it correct??

    Function CountCellpattern(CellPat As Range, rSumRange As Range)

    Dim rCell As Range
    Dim iPat As Integer
    Dim vResult

    iPat = CellPat.Interior.Pattern

    For Each rCell In rSumRange

    If iPat = 1 Then

    vResult = vResult + 1
    End If
    Next rCell

    CountCellpattern = vResult

    End Function
    Clough's Avatar
    Clough Posts: 26,677, Reputation: 1649
    Uber Member
    		  
    #2

    Jun 6, 2008, 01:34 AM
    I don't know if this is exactly what you are looking for, but the following site seems to have some good information concerning the counting of cells. I hope that it is helpful to you!

    http://www.contextures.com/xlFunctions04.html
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Jun 6, 2008, 06:55 AM
    What's not working? Have you tried stepping through the function?
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to count cells with colored font. [ 2 Answers ]

I'm have a spread sheet in Excel that has some cells fonts in red to indicate poor numbers. I want to know how I can count how many cells on the spread sheet have red font. I tried to do a COUNTIF command but I'm not sure if this is will count the colored font data.

How to Count Differences in Excel [ 2 Answers ]

I have to believe this is possible, but I'm stumped. If I have a list: Dog Dog Cat Cat Hamster Dog Cat Bird

Excel - Merge Cells [ 3 Answers ]

Any way to merge a number of cells into one cell, for example the title of many columns in a table?

Multi line cells in excel [ 4 Answers ]

Hey guys, any idea how to have multiple lines in a single cell in excel? I'm trying to make my table look a little neater, but it makes some of my comments overlap into following cells - is there any way to make the rows higher and to have 2 lines of text in a cell? Thanks in advance - Cap

View more questions Search