revealing format of a cell
 

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.

revealing format of a cell
 

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


"James Irwin" wrote in message
...
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.

revealing format of a cell
 

On Thu, 2 Oct 2008 04:48:04 -0700, James Irwin
wrote:

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

revealing format of a cell
 

Thank you very much for your help.

"Ron Rosenfeld" wrote:

On Thu, 2 Oct 2008 04:48:04 -0700, James Irwin
wrote:

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

revealing format of a cell
 

Thank you very much for your help, Bernie.

"Bernie Deitrick" wrote:

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


"James Irwin" wrote in message
...
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.