Results 1 to 7 of 7

Count Conditional Formatted Cells -2

Threaded View

  1. #1
    Registered User
    Join Date
    01-04-2010
    Location
    Ontario
    MS-Off Ver
    Excel 2013
    Posts
    12

    Count Conditional Formatted Cells -2

    I have a similar problem - to a thread with the same title
    http://www.excelforum.com/excel-gene...ted-cells.html

    I'm attempting to count cells that have been conditionally format based on the criteria that it matched the value in another cell. i.e. drawn lotto numbers that match my numbers played for particular draw.

    I'm looking to count the number of cells that are formatted.
    Conditional format applied to my number that match drawn number which have been input on sheet.

    =COUNTIF($B3:$AX3,BB3)>0 :: cells are coloured blue applies to :: =$BB$3:$EK$2918

    TIA
    Last edited by Ou812eh; 03-30-2011 at 05:07 PM.
    John

    Marie von Ebner-Eschenbach - "Even a stopped clock is right twice a day."

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