Is there a way to reference bold items within a formula?

[gml84]

I have a spreadsheet in Excel 2003 where one column where some items are bolded and some aren't. The issue is I would like to make a function that would be able to recognize the bolded items and divide those by 12 but not divide the non-bolded items. I have searched and have been unable to find if there is away Excel can differentiate bolded items from nonbolded items. Any help would be appreciated. Thanks.

[martindwilson]

try this code
put in a new module
select the range you want to do
run the macro

Please Login or Register  to view this content.

[sweep]

Hi, and welcome.

You'll need a custom function to determine if a cell is formatted bold.

This code is a start.

Please Login or Register  to view this content.

In your application, you could use it like this

=IF(ISBOLD(A1),A1/12,A1)

[Richard Buttrey]

Hi,

One way, assuming just one contiguous run of bold digits would be

Please Login or Register  to view this content.

[gml84]

Thanks for the replies. I am new to Visual Basic but it was easy with the formulas provided. It works and will save me a lot of time in the future. Thanks again!

[Richard Buttrey]

Hi,

It sounds like you've worked it out.
My code may be unnecessarily complicated since I'd assumed your request was indicating that the cell characters was a mixture of alpha numeric characters with the numerics bolded and you wanted to identify the numeric and divide by 12.

e.g. with 'abcde144def' in A1, =BoldDivide(A1) would return 12


From other responses it seems that the whole cell is either numeric or not.