+ Reply to Thread
Results 1 to 6 of 6

Can be count green marked cells?

  1. 01-05-2015, 05:09 AM #1
    toplisek
    toplisek is offline
    Forum Contributor
    Join Date
    02-02-2008
    Location
    EU
    MS-Off Ver
    MS Excel 2007 Professional version
    Posts
    214

    Can be count green marked cells?

    Can be count green marked cells?
    Reply With QuoteRegister To Reply
  2. 01-05-2015, 05:14 AM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Can be count green marked cells?

    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version.
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 01-05-2015, 05:14 AM #3
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Can be count green marked cells?

    do you mean is it possible to count the number of cells in a range that are a particular colour ?
    post an example please
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  4. 01-06-2015, 06:28 AM #4
    toplisek
    toplisek is offline
    Forum Contributor
    Join Date
    02-02-2008
    Location
    EU
    MS-Off Ver
    MS Excel 2007 Professional version
    Posts
    214

    Re: Can be count green marked cells?

    I have marked green areas and red areas and update profile regarding Excel version. I like to count green cells.
    Reply With QuoteRegister To Reply
  5. 01-06-2015, 07:01 AM #5
    Fotis1991
    Fotis1991 is offline
    Forum Expert 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: Can be count green marked cells?

    UDF


    Please Login or Register  to view this content.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    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.
    Reply With QuoteRegister To Reply
  6. 01-06-2015, 09:36 AM #6
    toplisek
    toplisek is offline
    Forum Contributor
    Join Date
    02-02-2008
    Location
    EU
    MS-Off Ver
    MS Excel 2007 Professional version
    Posts
    214

    Re: Can be count green marked cells?

    Hi, it seems the easy way to set column with numbers like 1 and it counts solved tasks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 Percentages Red to Green - Negatives Red, Positives Green
    By willmcb in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-06-2014, 04:31 AM
  2. Change colour of cell relative to date. (Passed-Green, Today-Orange Future-Green)
    By lukefallon in forum Excel General
    Replies: 6
    Last Post: 08-23-2012, 12:14 PM
  3. Need to count if X = 1.2 and Y = green... help
    By caitfox in forum Excel General
    Replies: 5
    Last Post: 05-26-2011, 10:02 AM
  4. Listing cells which have been marked
    By twofootgiant in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2011, 05:22 AM
  5. count coloured cells in a range. Specific colour Red, Green, Blue
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 05-16-2006, 05:20 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1