ExcelBanter - Count Occourences of formatted text

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count Occourences of formatted text (https://www.excelbanter.com/excel-discussion-misc-queries/2256-count-occourences-formatted-text.html)

Adam

Count Occourences of formatted text

I'd like to be able to count the number of cells that have a certain color
text, or are bold. can anyone tell me how to do this?

thanks!
adam

Frank Kabel

Hi
see:
http://www.xldynamic.com/source/xld.ColourCounter.html
and
http://www.cpearson.com/excel/colors.htm

--
Regards
Frank Kabel
Frankfurt, Germany
"Adam" schrieb im Newsbeitrag
...
I'd like to be able to count the number of cells that have a certain color
text, or are bold. can anyone tell me how to do this?

thanks!
adam

All times are GMT +1. The time now is 02:48 PM.