revealing format of a cell

[James Irwin]

Hi - Is there a formula that allows me to reveal a cell's format in Excel
2003? I want to be able to distinguish between cells in bold font (e.g.
return "true") vs cells not in bold font (e.g. return "false")? Any help
appreciated! Thanks.

 

[Bernie Deitrick]

James,

You would need to use a custom, user-defined function, coded in VBA.

For example

Function IsBold(r As Range) As Boolean
IsBold = R.Font.Bold
End Function

used like

=IsBold(A1)

but it won't recalc automatically - use Ctrl-Shift-F9 - and it won't reveal bolding applied by
Conditional formatting. That is a whole other kettle of fish.


HTH,
Bernie
MS Excel MVP

 

[Ron Rosenfeld]

Hi - Is there a formula that allows me to reveal a cell's format in Excel
2003? I want to be able to distinguish between cells in bold font (e.g.
return "true") vs cells not in bold font (e.g. return "false")? Any help
appreciated! Thanks.

You could download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr/ and then use the XLM.GET.CELL function.
--ron

 

[James Irwin]

Thank you very much for your help.

You could download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr/ and then use the XLM.GET.CELL function.
--ron

 

[James Irwin]

Thank you very much for your help, Bernie.

James,

You would need to use a custom, user-defined function, coded in VBA.

For example

Function IsBold(r As Range) As Boolean
IsBold = R.Font.Bold
End Function

used like

=IsBold(A1)

but it won't recalc automatically - use Ctrl-Shift-F9 - and it won't reveal bolding applied by
Conditional formatting. That is a whole other kettle of fish.


HTH,
Bernie
MS Excel MVP