+ Reply to Thread
Results 1 to 3 of 3

Count cell by colour

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    chennai
    MS-Off Ver
    Excel 2010
    Posts
    53

    Count cell by colour

    I want to count cell by color.

    Me and my back to working rotations and I have a excel sheet for the whole year working days marked in different color. I want to count how many days we worked (marked) counting by color. I need a simple countif formula, if possible.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,567

    Re: Count cell by colour

    I need a simple countif formula, if possible
    Regular excel formulas cannot count color. Color is formatting, not data

    Having said that, is there some logic to how the colors were applied? perhaps we can base the count off that, and not the color?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-11-2013
    Location
    chennai
    MS-Off Ver
    Excel 2010
    Posts
    53

    Re: Count cell by colour

    Quote Originally Posted by FDibbins View Post
    Regular excel formulas cannot count color. Color is formatting, not data

    Having said that, is there some logic to how the colors were applied? perhaps we can base the count off that, and not the color?
    Yes, I understand now.

    Thanks for the reply.

    Regards,

    Ravi

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Count cell background colour
    By sats43 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-04-2010, 07:08 AM
  2. cell colour with count if
    By spinkung in forum Excel General
    Replies: 1
    Last Post: 03-02-2009, 09:58 AM
  3. [SOLVED] Count Filled colour in cell in given range
    By sizz1@hotmail.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2006, 06:30 AM
  4. [SOLVED] Count filled colour in cell in given range
    By sizz1@hotmail.com in forum Excel General
    Replies: 2
    Last Post: 05-16-2006, 05:25 AM
  5. Formula to count Cell colour.
    By themax16 in forum Excel General
    Replies: 3
    Last Post: 05-29-2005, 09:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1