+ Reply to Thread
Results 1 to 4 of 4

Counting cells in a column that have been conditionally formatted as out of date

  1. #1
    Registered User
    Join Date
    12-03-2020
    Location
    Cardiff
    MS-Off Ver
    365 pro plus
    Posts
    9

    Counting cells in a column that have been conditionally formatted as out of date

    Hi I have a training workbook that has 2 columns per person for capturing training dates. In the pic the cells in Column I are populated with M or M* column J is used for entry of dates when training has been completed. Column J is conditionally formatted to turn green if within date and red if out of date - my problem is my countif formula in I32 ( =COUNTIFS(J115:J128,">1",$A115:$A128,"eLearning",I115:I128,"M") works but i would like it not to count dates that are in red. Is there a simple way to do this?

    Thanks in advance for any help






    Capture.JPG

  2. #2
    Registered User
    Join Date
    04-13-2016
    Location
    Central Wisconsin
    MS-Off Ver
    2013
    Posts
    1

    Re: Counting cells in a column that have been conditionally formatted as out of date

    Sumit Bansal has developed three different ways to count cells by color. Hope one of these works for you.

    https: // trumpexcel.com/count-colored-cells-in-excel/

  3. #3
    Registered User
    Join Date
    12-03-2020
    Location
    Cardiff
    MS-Off Ver
    365 pro plus
    Posts
    9

    Re: Counting cells in a column that have been conditionally formatted as out of date

    thanks for your help but sadly that only works for manually filled cells and not for cells with Conditional formatted colour

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,125

    Re: Counting cells in a column that have been conditionally formatted as out of date

    Use the rule you used to conditionally format the cells red as your extra COUNTIFS criterion.

    Attach a sample workbook if you want more specific guidance.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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. [SOLVED] Counting conditionally formatted cells which are blank?
    By as9178 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-07-2020, 10:48 AM
  2. [SOLVED] Counting Conditionally-Formatted Cells in a Row
    By eNinjaInTraining in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2020, 03:33 PM
  3. [SOLVED] Counting Conditionally Formatted Coloured Cells
    By Tiraenus in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-23-2018, 08:03 PM
  4. Counting coloured cells that are conditionally formatted
    By vmutch in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-24-2015, 02:46 PM
  5. counting conditionally formatted cells
    By chop924 in forum Excel General
    Replies: 3
    Last Post: 05-09-2012, 11:44 AM
  6. Counting by conditionally formatted cells
    By genus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-23-2009, 05:42 AM
  7. Counting conditionally formatted cells
    By Nigel in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-27-2008, 04:00 PM

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