ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Count of Cells Based on Format (https://www.excelbanter.com/excel-discussion-misc-queries/154322-count-cells-based-format.html)

Dawg House Inc

Count of Cells Based on Format
 
I have compiled a matrix and I have various items have already been formatted
to bold various values based on the location the process that they appear -
not the best way of collecting/presenting the data, but its been collected
for 78 applications, so its not being changed at the moment.

Anyhow, what I wanna be abel to do is this - count the items tagged with
"x", but specifically, count the items that are bolded X's. Some have "x",
while some have a bolded X.

Is there a formula that I can use that will allow me to count just the
bolded X's? (this applies to a variety of values as well).

Thanks in advance.
JCH
--
Dawg House Inc.
"We live in it, therefore, we know it!"

Gary''s Student

Count of Cells Based on Format
 
See:

http://www.cpearson.com/excel/colors.htm


--
Gary''s Student - gsnu200737


"Dawg House Inc" wrote:

I have compiled a matrix and I have various items have already been formatted
to bold various values based on the location the process that they appear -
not the best way of collecting/presenting the data, but its been collected
for 78 applications, so its not being changed at the moment.

Anyhow, what I wanna be abel to do is this - count the items tagged with
"x", but specifically, count the items that are bolded X's. Some have "x",
while some have a bolded X.

Is there a formula that I can use that will allow me to count just the
bolded X's? (this applies to a variety of values as well).

Thanks in advance.
JCH
--
Dawg House Inc.
"We live in it, therefore, we know it!"



All times are GMT +1. The time now is 10:08 AM.

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