Formula to count colored cells?

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Formula to count colored cells?

  1. #1
    New Member
    Join Date
    Jul 2011
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Formula to count colored cells?

    In Excel 2007, is there a way to count the number of colored cells in a column? The cells are not automatically formatted with color, but instead are filled with color manually on an individual basis. There are different colors based on the appropriate situation for each cell. Thanks!

  2. #2
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Formula to count colored cells?

    HTH, Peter
    Please test any code on a copy of your workbook.

  3. #3
    New Member
    Join Date
    Jul 2011
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula to count colored cells?

    PERFECT! Thank you so much!!!

  4. #4
    MrExcel MVP
    Int'l Moderator
    Greg Truby's Avatar
    Join Date
    Jun 2002
    Location
    39 17' 15" N, -94 40' 26" W
    Posts
    9,962
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Formula to count colored cells?

    FYI - Chip's got a ton of color-related stuff if you ever need more.

    http://www.cpearson.com/excel/colors.aspx
    Greg

    Home: XL 2003, 2007, 2010, and 2013 on Windows 7
    Work: XL 2013, 2016 on Windows 10
    Please use CODE tags - especially for longer excerpts of code.

User Tag List

Tags for this Thread

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