+ Reply to Thread
Results 1 to 2 of 2

Count cells which meet the conditional formatting criteria

  1. #1
    Registered User
    Join Date
    10-02-2008
    Location
    arkansas
    Posts
    2

    Count cells which meet the conditional formatting criteria

    I have made an excel fill in the blank quiz using conditional formatting, I was wondering how to have a seperate cell on the sheet showing the total number of cells (correct answers) where the student has met the condition out of the total number possible, Thanks for any help. data validation? or something else, I have know idea but I know there is a way to do it.

    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626

    See the attachment

    I have attached a sample file.
    I think it can help you
    Attached Files Attached Files
    I need your support to add reputations if my solution works.


+ 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. conditional formatting with blank cells
    By maacmaac in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2008, 12:22 PM
  2. Replies: 9
    Last Post: 03-24-2008, 03:04 PM
  3. One criteria AND cell is blank in conditional formatting formula?
    By westis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2008, 06:37 PM
  4. Conditional Format for a Range of Cells
    By jonlemur in forum Excel General
    Replies: 2
    Last Post: 08-11-2007, 09:53 PM
  5. Conditional Formatting for Blank Cells
    By modest_16081982 in forum Excel General
    Replies: 3
    Last Post: 07-30-2007, 03:44 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