+ Reply to Thread
Results 1 to 4 of 4

Adding text in a cell that is color coded

  1. #1
    Registered User
    Join Date
    04-19-2011
    Location
    Florida, US
    MS-Off Ver
    Excel 2007
    Posts
    38

    Adding text in a cell that is color coded

    Is it possible to add text in cells by color?
    If a client cancels we mark the client in red. Can I get it to add/count the text in a cell based on a color so that it gives me a total of clients that canceled per agent based on the color of the cell?
    I attached a form that Jakobshavn supplied(thank you). In the example sheet...
    column D is the client, client 1, 4, 9 and 12 cancelled. The agent is listed and colored red, showing who's deal that cancelled. In column H it shows how many deals cancelled for the agent. Is this possible?

    Thanks in advance to all that reply!

    P.S. Count of Names (1).xlsxI did ask this in another forum I started, but I marked as solved and wanted to start over since it is a different question in it's entirety. Sorry if this is wrong.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,173

    Re: Adding text in a cell that is color coded

    You might need to use a UDF for that.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-19-2011
    Location
    Florida, US
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: Adding text in a cell that is color coded

    Thank you! Looking at the formula, it makes total sense!

  4. #4
    Registered User
    Join Date
    04-19-2011
    Location
    Florida, US
    MS-Off Ver
    Excel 2007
    Posts
    38

    Re: Adding text in a cell that is color coded

    JieJenn, thank you for your input. It worked almost perfectly. The almost is not do to the formula but macros. I forgot about enable macros and the nuisance it causes. So I was wondering...
    Is there any other way to solve my issue, a way to "add/count text in a cell by color" without macros??

    Thanks again for all the input! Much appreciated!

    Quote Originally Posted by JieJenn View Post
    You might need to use a UDF for that.

    Please Login or Register  to view this content.

+ 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