ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   count by specific text color in range of cell (https://www.excelbanter.com/excel-discussion-misc-queries/81311-count-specific-text-color-range-cell.html)

Tii99

count by specific text color in range of cell
 

Anyone, please help. I'd like to use a formula to count character in
range of cell which text are RED color.


--
Tii99
------------------------------------------------------------------------
Tii99's Profile: http://www.excelforum.com/member.php...o&userid=33142
View this thread: http://www.excelforum.com/showthread...hreadid=529506


Bob Phillips

count by specific text color in range of cell
 
See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tii99" wrote in
message ...

Anyone, please help. I'd like to use a formula to count character in
range of cell which text are RED color.


--
Tii99
------------------------------------------------------------------------
Tii99's Profile:

http://www.excelforum.com/member.php...o&userid=33142
View this thread: http://www.excelforum.com/showthread...hreadid=529506




Tii99

count by specific text color in range of cell
 

Thank you very much Bob for your help, I'll try that out

:)


--
Tii99
------------------------------------------------------------------------
Tii99's Profile: http://www.excelforum.com/member.php...o&userid=33142
View this thread: http://www.excelforum.com/showthread...hreadid=529506



All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com