+ Reply to Thread
Results 1 to 2 of 2

How to count conditinal foramtting colored cell

  1. #1
    Registered User
    Join Date
    04-23-2018
    Location
    MALAYSIA
    MS-Off Ver
    MS EXCEL 2016
    Posts
    3

    How to count conditinal foramtting colored cell

    Hi,

    Could you help me in counting the conditional formatting colored cells? I cannot count it properly.. I want to count the yellow and red colored cell for every description involved. The formula conditional formatting that I'm use is, format cell that contain. Yellow color cell for the value below the low value and red color cell for the value that are above high value. But the cell cannot be counted using normal way..

    Tq.
    Attached Images Attached Images
    Last edited by Ogy Ramly; 04-24-2018 at 11:47 PM.

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,615

    Re: How to count conditinal foramtting colored cell

    Try using a formula for the CF and use the same conditions for the counting formula.
    Dave

+ 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] Count Consecutive Colored Cell Ranges
    By Logit in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-19-2017, 04:46 PM
  2. How to count only colored cell and extract details of colored cell's row
    By bala04msw in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-23-2016, 07:03 AM
  3. 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
  4. 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
  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. 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