+ Reply to Thread
Results 1 to 7 of 7

trying to get a function to recognize differece between bold font and regular font

  1. #1
    Registered User
    Join Date
    04-09-2014
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2010
    Posts
    4

    trying to get a function to recognize differece between bold font and regular font

    I would like to get an if function that will display the bold item and need help writing it could someone help me out

    here is a basic example of what I am looking for, I want the bolded text in column B to continue on each line item in column A until the next bolded text in column B

    A B
    Dog Dog
    Dog 1.00
    Dog 2.00
    Dog 3.00
    Cat Cat
    Cat 1.00
    Cat 2.00

    let me know if you would be able to help me create this

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,445

    Re: trying to get a function to recognize differece between bold font and regular font

    Assuming the data starts in Row 2, then:

    A2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and copy down.

    It's not checking for bold though and, AFAIK, you can't test for that in a worksheet function ... but I might be wrong.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    04-09-2014
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: trying to get a function to recognize differece between bold font and regular font

    looking for the bold application that one won't work exactly how I need it to

  4. #4
    Registered User
    Join Date
    04-09-2014
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: trying to get a function to recognize differece between bold font and regular font

    Function IfBold(Cell)
    If Cell.Font.Bold = True Then
    IfBold = 1
    Else
    IfBold = 0
    End If
    End Function

    I was trying to make a function that would at least separate the bold from the not bold and my function isn't working could someone help me out with it?

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,445

    Re: trying to get a function to recognize differece between bold font and regular font

    It would look something like this:

    Please Login or Register  to view this content.

    Note that changing from bold to plain text or vice versa won't cause the formula to update. Changing formatting doesn't cause the worksheet to be calculated. It will only update when a calculation happens (or is forced).


    Regards, TMS

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,445

    Re: trying to get a function to recognize differece between bold font and regular font

    Guess this is shorter ...

    Please Login or Register  to view this content.

    Regards, TMS

  7. #7
    Registered User
    Join Date
    04-09-2014
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: trying to get a function to recognize differece between bold font and regular font

    still havening problems so when I put this function into excel and nothing. is there something I'm missing like how to enable these functions or something. I am a beginner at this so I probably need a step by step

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,445

    Re: trying to get a function to recognize differece between bold font and regular font

    Please provide a sample workbook with some typical data and the code in place.

    Regards, TMS

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Not being able to change from bold to regular font
    By DClarkin in forum Excel General
    Replies: 1
    Last Post: 07-10-2013, 07:16 PM
  2. Need BOLD Font in VBA
    By rsanti in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-03-2012, 08:22 PM
  3. VBA - Add Font Bold
    By Redd in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-15-2007, 03:57 PM
  4. Replies: 1
    Last Post: 11-07-2007, 08:45 PM
  5. Bold Font
    By scantor145 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2006, 09:15 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1