Results 1 to 4 of 4

Thread: Formula to count colored cells?

  1. #1

    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

    Default Re: Formula to count colored cells?

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

  3. #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,898

    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.

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