Counting by Fill Color
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Counting by Fill Color

  1. #1
    Guest

    Default

     
    Help! I need a formula that will enable my spread sheet to count the different colors of cells. For example: A column from B2 to B10 has three different shades of color(red, yellow, and green), I would like cell B12 to tell me how many "reds" there are, cell B13 shows how many "yellows" and B14 shows the "greens". Any ideas? I've tried several formulas based on the color index number, but to no avail. Thanks.

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Use the Search function of the board. This question has been addressed several times recently.

    Veni, Vidi, Velcro - I came, I saw, I stuck around

    Taxation WITH representation ain't so hot either

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Friend,

    goto site..www.pexcel.com

    here download file...

    countingcolorindex.

    this a small utility made by me .. and it is just for free...

    ni****h


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com