+ Reply to Thread
Results 1 to 2 of 2

How do I use cell color in formulas?

Hybrid View

  1. #1
    Mike
    Guest

    How do I use cell color in formulas?

    Is there some way I can create a function that uses the cell color? What I
    want to do is something like

    COUNT IF cell-color = magenta

  2. #2
    Paul B
    Guest

    Re: How do I use cell color in formulas?

    Mike, have a look here for a way to do it,

    http://www.cpearson.com/excel/colors.htm
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "Mike" <Mike@discussions.microsoft.com> wrote in message
    news:647A8061-7AD4-4923-96FF-F881052FC90D@microsoft.com...
    > Is there some way I can create a function that uses the cell color? What I
    > want to do is something like
    >
    > COUNT IF cell-color = magenta




+ 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