Results 1 to 4 of 4

Formula to count colored cells?

This is a discussion on Formula to count colored cells? within the Excel Questions forums, part of the Question Forums category; In Excel 2007, is there a way to count the number of colored cells in a column? The cells are ...

  1. #1
    New Member
    Join Date
    Jul 2011
    Posts
    3

    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
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,565

    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

    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,770

    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

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

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