Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count text cells based on two criteria | Excel Worksheet Functions | |||
count cells,containing text, based on more than one criteria? | Excel Worksheet Functions | |||
Count cells based on value in a range | Excel Discussion (Misc queries) | |||
how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
count number of cells based on TWO conditions (2 different columns | Excel Worksheet Functions |