+ Reply to Thread
Results 1 to 3 of 3

Can I count cells with specific format (e.g., yellow field?)

  1. #1
    umaanddottie
    Guest

    Can I count cells with specific format (e.g., yellow field?)

    I am trying to count cells that have a specific field color, such as green or
    yellow. I'm scheduling emergency duty and need to make sure that the awful
    shifts (Friday nights and Saturday nights) get distributed evenly among the
    30 interns/residents doing duty. I have the shift rows highlighted across
    the list of names to be schedules. I've used the COUNTIF function to count
    occurances of things, but it only accepts words, numbers, etc. as criteria.
    Any ideas?

  2. #2
    Peo Sjoblom
    Guest

    Re: Can I count cells with specific format (e.g., yellow field?)

    You would need VBA for that, however if the colours are weekday dependent
    you might be able to use the day itself as criteria, for counting colours
    see

    http://www.cpearson.com/excel/colors.htm

    on how to install VBA see:

    http://www.mvps.org/dmcritchie/excel/install.htm


    Regards,

    Peo Sjoblom

    (No private emails please)


    "umaanddottie" <[email protected]> wrote in message
    news:[email protected]...
    >I am trying to count cells that have a specific field color, such as green
    >or
    > yellow. I'm scheduling emergency duty and need to make sure that the
    > awful
    > shifts (Friday nights and Saturday nights) get distributed evenly among
    > the
    > 30 interns/residents doing duty. I have the shift rows highlighted across
    > the list of names to be schedules. I've used the COUNTIF function to
    > count
    > occurances of things, but it only accepts words, numbers, etc. as
    > criteria.
    > Any ideas?



  3. #3
    PC
    Guest

    Re: Can I count cells with specific format (e.g., yellow field?)

    Chip Pearson has these custom functions that return the color. Instead of
    sorting you can use a SUMPRODUCT to count the colors by person.

    http://cpearson.com/excel/SortByColor.htm

    If you're not familiar with using SUMPRODUCT to count the items, I recommend
    you get those functions working first and then do a google search to get
    that formula. (It is posted on this newsgroup a least once a day (A search
    for "counting with multiple criteria" should return the syntaxt)

    PC

    "umaanddottie" <[email protected]> wrote in message
    news:[email protected]...
    > I am trying to count cells that have a specific field color, such as green

    or
    > yellow. I'm scheduling emergency duty and need to make sure that the

    awful
    > shifts (Friday nights and Saturday nights) get distributed evenly among

    the
    > 30 interns/residents doing duty. I have the shift rows highlighted across
    > the list of names to be schedules. I've used the COUNTIF function to

    count
    > occurances of things, but it only accepts words, numbers, etc. as

    criteria.
    > Any ideas?




+ 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