| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Revealing the related pivot data | Excel Discussion (Misc queries) | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| revealing the contents of a formula | Excel Worksheet Functions | |||
| Again-revealing the contents of formula | Excel Worksheet Functions | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Hybrid Mode
