+ Reply to Thread
Results 1 to 5 of 5

Formula to Check for Font Size

  1. #1
    Registered User
    Join Date
    06-20-2013
    Location
    New Jersey, USA
    MS-Off Ver
    Mac Excel 2008
    Posts
    18

    Formula to Check for Font Size

    Hi. I want know if there is a way to see if a certain cell has a specific font size. For instance, I want to say like if A1 is equal to font size 8.5, then keep. Thanks. Pat

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Formula to Check for Font Size

    you will need a UDF. Create a module for this function in your spreadsheet:
    Please Login or Register  to view this content.
    Then =Fontsize(A5) will tell you the fontsize for A5.

    Oops, after posting I see that you have Mac Excel 2008. I don't think that supports VBA. So, there is no Excel function to tell you font size.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

  3. #3
    Registered User
    Join Date
    06-20-2013
    Location
    New Jersey, USA
    MS-Off Ver
    Mac Excel 2008
    Posts
    18

    Re: Formula to Check for Font Size

    Oh no worry. I have PC excel 2013 that would work. Thank

  4. #4
    Registered User
    Join Date
    06-20-2013
    Location
    New Jersey, USA
    MS-Off Ver
    Mac Excel 2008
    Posts
    18

    Re: Formula to Check for Font Size

    How would I exactly put that into VBA? Thanks

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,416

    Re: Formula to Check for Font Size

    Pat, just a bit of info...excel works with data - numbers/text/dates etc, formatting is a cosmetic change and is not data. Therefore, excel cannot "see" colors, fonts, bolds, underlines etc, you need VBA for that.

    The formatting is just there to make it easier for people (humans, as opposed to PC's) to see things better, excel needs none of that to do it's job
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Changing font size within a formula
    By doowop5000 in forum Excel General
    Replies: 1
    Last Post: 05-14-2008, 03:07 PM
  2. Check Box Font size
    By Determined in forum Excel General
    Replies: 1
    Last Post: 05-05-2007, 03:19 PM
  3. Font size smaller and bigger in a formula
    By Gary T in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-10-2006, 11:55 AM
  4. Font Size in Check Box
    By Beetlejuice in forum Excel General
    Replies: 2
    Last Post: 08-25-2005, 10:05 AM
  5. Forms Check Box Font Size
    By gjs in forum Excel General
    Replies: 2
    Last Post: 02-02-2005, 02:06 PM

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