+ Reply to Thread
Results 1 to 4 of 4

I want to count colored cells based on date

  1. #1
    Registered User
    Join Date
    02-15-2016
    Location
    toronto
    MS-Off Ver
    2013
    Posts
    2

    Exclamation I want to count colored cells based on date

    asadasdasdasdasd
    Last edited by mkumar714; 05-04-2017 at 09:42 AM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: I want to count colored cells based on date

    Hi,
    What is colouring the cells? Is that a conditional format or have you manually painted them.

    And if the green & yellow cells are restricted to the columns you show, (i.e. no one column has both green and yellow dates) then just use a COUNTIFS() function specifying >= the month start and <= month end
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    02-15-2016
    Location
    toronto
    MS-Off Ver
    2013
    Posts
    2

    Re: I want to count colored cells based on date

    Hi,

    The cells are tasks, if completed it turns green else it turns yellow. They are conditional formatting.

    The gree and yellow cells are not restricted to the columns as shown. Sometimes it may be available in the same column.

    I am unable to use COUNTIFS() if two colors are present in one column.

  4. #4
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,340

    Re: I want to count colored cells based on date

    If it is conditional formatting then use the formula you use for conditional formatting to count them.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

+ 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. a count based on how many cells are colored in
    By R1_Canuck in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2016, 06:31 AM
  2. UDF to count colored cells always gives zero
    By capson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-04-2015, 02:01 PM
  3. Count colored cells based on criteria from other cells
    By gdaniels in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-11-2014, 08:32 PM
  4. Replies: 1
    Last Post: 11-09-2013, 02:43 AM
  5. Colored Cells for Deadlines based on todays date
    By ExtCare in forum Excel General
    Replies: 7
    Last Post: 06-19-2012, 10:22 AM
  6. Excel 2007 : Count colored cells in vba
    By nlm in forum Excel General
    Replies: 4
    Last Post: 08-25-2011, 07:58 AM
  7. Count colored cells?
    By mlk in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-30-2007, 06:30 PM

Tags for this Thread

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