+ Reply to Thread
Results 1 to 6 of 6

count conditionally formatted cells

  1. #1
    Registered User
    Join Date
    11-17-2011
    Location
    Shropshire
    MS-Off Ver
    Excel 2010
    Posts
    79

    count conditionally formatted cells

    can you could cells which have been conditionally formatted?

    I've coloured the background in red so basically I want to count how many red cells are on that row.

    I've used a formular for formatting which is = =ISNUMBER(SEARCH("/06",A1:ZZ200))

    Thanks.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: count conditionally formatted cells

    Hi

    To avoid to use VBA(You can not count colored cells using formula), you can use a helper column and in each row to count how many "/06" exist.

    Then use SUM to add these numbers.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    11-17-2011
    Location
    Shropshire
    MS-Off Ver
    Excel 2010
    Posts
    79

    Re: count conditionally formatted cells

    Thanks for reply - not good with vba so will have to look at doing something else.
    x

  4. #4
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: count conditionally formatted cells

    helper column?

  5. #5
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: count conditionally formatted cells

    How about?

    =COUNTIF(A1:ZZ200,"*/06*")
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  6. #6
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: count conditionally formatted cells

    Quote Originally Posted by NBVC View Post
    How about?

    =COUNTIF(A1:ZZ200,"*/06*")
    Ha Ha! Simple is always the best!

+ 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