+ Reply to Thread
Results 1 to 5 of 5

How to count only colored cell and extract details of colored cell's row

  1. #1
    Forum Contributor
    Join Date
    08-19-2016
    Location
    Chennai, India
    MS-Off Ver
    2007
    Posts
    300

    How to count only colored cell and extract details of colored cell's row

    Dear Forum,

    I need your support for the following situation:

    1. The attached worksheet is macro recorded sheet and (kindly enable while you are opening) has 2 sheets.
    2. Data set - GA is a master document and GA - Worksheet is a report generation sheet, which generating report from Data set GA sheet with specific criteria.
    3. The Data set - GA gives you very clear picture about individuals submitted application for Loan and sanctioned details. "Column J" has conditional formatting option to get to know about the status of loan amount sanctioned. "Blue color indicates application submitted but still loan amount is not sanctioned". "Green color indicates application submitted and loan amount sanctioned".

    Now my requirements are in the GA - Worksheet only:

    1. 1st requirement is - I have setup count cell in C2 with formula. Currently it gives me entire blank cells from J4:J63. But i want only "count of Blue color"
    2. My 2nd requirement is - I need to extract those count numbers individual details from Data set - GA in the structured table. (A5:J5)

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How to count only colored cell and extract details of colored cell's row

    filter on blue cells and use:

    j1 =SUBTOTAL(103,D4:D65)
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How to count only colored cell and extract details of colored cell's row

    duplicate post (forum-issue).

  4. #4
    Forum Contributor
    Join Date
    08-19-2016
    Location
    Chennai, India
    MS-Off Ver
    2007
    Posts
    300

    Re: How to count only colored cell and extract details of colored cell's row

    Dear Mr. Oeldere,

    Thanks for your prompt support. The sheet, i have attached is dynamic entry sheet. i.e., keep on adding rows. More over i wanted to have those count details of blue color in GA sheet C2 cell with the assistance of formula and data extracted in the table also.

    Thanks

    Bala

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How to count only colored cell and extract details of colored cell's row

    Then change the range.

    j1 =SUBTOTAL(103,D4:D5000)

    Why you want to have the colored data on another sheet (what is the use for that?).

+ 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. Cell colored, but not colored when printed?
    By richard11153 in forum Excel General
    Replies: 1
    Last Post: 02-08-2016, 03:23 PM
  2. Formula or VBA to count the colored Cell
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2014, 09:40 AM
  3. How to count colored cells per each cell range?
    By gabrielemucho in forum Excel General
    Replies: 4
    Last Post: 10-21-2014, 07:31 AM
  4. Replies: 1
    Last Post: 11-09-2013, 02:43 AM
  5. Use count if cell is colored
    By Moongoddess in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-12-2012, 01:18 PM
  6. Count colored cell?
    By elfiky in forum Excel General
    Replies: 1
    Last Post: 08-24-2008, 08:27 PM
  7. [SOLVED] Count depth of Colored Cell
    By smandula in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2005, 03:05 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