+ Reply to Thread
Results 1 to 4 of 4

Count non-colored cells

  1. #1
    Ken G
    Guest

    Count non-colored cells

    I have a sheet that highlights cells in a range if any of
    those cells contain values from a manually entered range
    using the "countif" function and conditional formatting.

    How do I count the number of cells which have been
    conditionally formatted - with a fill color.

  2. #2
    Ken G
    Guest

    Count non-colored cells


    >-----Original Message-----
    >I have a sheet that highlights cells in a range if any of
    >those cells contain values from a manually entered range
    >using the "countif" function and conditional formatting.
    >
    >How do I count the number of cells which have been
    >conditionally formatted - with a fill color.
    >.

    Sorry - the Subject Line should have been "Count colored cells"

  3. #3
    Frank Kabel
    Guest

    Re: Count non-colored cells

    Hi
    though this is possible it's a little bit complicated. Why not use the same
    criteria in a formula as you have don in the conditional format dialog
    ()e.g. use COUNTIF)

    --
    Regards
    Frank Kabel
    Frankfurt, Germany
    "Ken G" <anonymous@discussions.microsoft.com> schrieb im Newsbeitrag
    news:041d01c4f0bf$c9ef00c0$3a01280a@phx.gbl...
    >I have a sheet that highlights cells in a range if any of
    > those cells contain values from a manually entered range
    > using the "countif" function and conditional formatting.
    >
    > How do I count the number of cells which have been
    > conditionally formatted - with a fill color.




  4. #4
    Don Guillett
    Guest

    Re: Count non-colored cells

    look here
    http://www.cpearson.com/excel/cfcolors.htm

    --
    Don Guillett
    SalesAid Software
    donaldb@281.com
    "Ken G" <anonymous@discussions.microsoft.com> wrote in message
    news:041d01c4f0bf$c9ef00c0$3a01280a@phx.gbl...
    > I have a sheet that highlights cells in a range if any of
    > those cells contain values from a manually entered range
    > using the "countif" function and conditional formatting.
    >
    > How do I count the number of cells which have been
    > conditionally formatted - with a fill color.




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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