Since the text is bolded only if the cell contains a space character,
you could use
=SUMPRODUCT(--(A1:A3=" "),--(B1:B3<>"")) ==> 2
=SUMPRODUCT(--(A1:A3=" "),--(C1:C3<>"")) ==> 1
In article <A2311A7B-9201-4B1A-ACF8-04DD7DED529D@microsoft.com>,
philip <philip@discussions.microsoft.com> wrote:
> I have post my question yesterday, seem there is no solution?? Is there
> anybody can give me some alternative way to do it, will be greatly appreciate.
>
> my problem is
>
> Is there anyway to count the cell with bolded text (the text is bolded by
> conditional format), the criteria is
> 1- $A1=" " > format text to bold
> 2- $A1>=1 > format text to color "blue" & "italic"
> 3- $A1="xx" > format text to color "red" & "italic"
>
> will show:-
>
> A B C D...
> 1 " " P1 P2 (bolded text by CF)
> 2 " " S1 (bolded text by CF)
> 3 1 x1
> ___________________________
> count: 2 1
>
>
> Please HELP
>
> MANY THANKS
> philip
Bookmarks