revealing format of a cell

  • Thread starter Thread starter James Irwin
  • Start date Start date
J

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.
 
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
 
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.
Click to expand...

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
 
Thank you very much for your help, Bernie.

Bernie Deitrick said:
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
Click to expand...
 
Back
Top