If statement where bold text is the key

[bayoung]

Is it possible to create an "If" statement where if a cell contains bold text, the answer is 1, and if not, the answer is 0?

 

[Tazguy37]

In VBA you can; not so sure about a formula solution....

 

[Tom Urtis]

The short answer is yes.

The long answer is, yes but it depends on how your cells got bolded.

If the bold format is due to the cell's font property being set to "Bold" (such as when you click on Format > Cells > Font Tab) then

You will need a user defined function in VBA to construct a formula to identify the bold property.

Otherwise if the font is bold due to conditional formatting then

you can get by with a formula that tests for the same condition in the subject cell as does the conditional formatting.


So, clarify what you really have and someone can assist with a formula that is appropriate for your situation.

 

[Krishnakumar]

Hi,

PivotTest.xls
	A	B	C	D
1	a	0
2	b	1
3	c	0
4	d	1
5	e	0
6	f	1
7	g	0
8	h	1
9	I	0
10	j	1
Sheet2

Bold defined as

=GET.CELL(20,Sheet2!$A1)

HTH

 

[bayoung]

The formatting is not conditional - hopefully this will make the answer easier

 

[Scott Huish]

You will have to do a Recalc (F9) if you change the bolding for it to update after changes, but perhaps:

Public Function isbold(r As Range) As Integer
Application.Volatile
isbold = Abs(r.Font.Bold = True)
End Function