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.
Bookmarks