+ Reply to Thread
Results 1 to 12 of 12

multiply if bold

  1. #1
    Registered User
    Join Date
    06-18-2012
    Location
    South Yorkshire
    MS-Off Ver
    Excel 2007
    Posts
    10

    multiply if bold

    Hi, first time poster....

    Just wandered if you could help with a problem I have?

    I've been trying to change the following code at http://www.mcgimpsey.com/excel/udfs/sumbold.html so that it multiplies the bold values instead of summing them.


    Basically - I have a row of values that when certain ones are made bold the bold values should be multiplied by each other

    Thanks

    Graham
    Last edited by Baphomay; 09-12-2012 at 05:19 PM.

  2. #2
    Registered User
    Join Date
    09-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007/10
    Posts
    45

    Re: multiply if bold

    please select the data in row/column acrosss which you want to multiply if bold and then run this code

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-18-2012
    Location
    South Yorkshire
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: multiply if bold

    Hi pooja_deshpande,

    that works great, but is it possible for the returned value to be in a cell instead of the message box?

    Thanks

    Graham

  4. #4
    Registered User
    Join Date
    06-18-2012
    Location
    South Yorkshire
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: multiply if bold

    Bump..

    Anyone? can you help please?

    Graham

  5. #5
    Registered User
    Join Date
    08-27-2012
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: multiply if bold

    Try this
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    06-18-2012
    Location
    South Yorkshire
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: multiply if bold

    Hi,

    here's what I'm trying to do?

    Columns headings are C D E | F G H | I
    and the rows are row 20 to row 35


    Likelihood | Severity | Risk Score

    > 1 2 3 | 1 2 3 | = 6

    1 2 3 | 1 2 3 | = if font is bold answer here
    1 2 3 | 1 2 3 | = if font is bold answer here
    1 2 3 | 1 2 3 | = if font is bold answer here
    1 2 3 | 1 2 3 | = if font is bold answer here
    1 2 3 | 1 2 3 | = if font is bold answer here
    1 2 3 | 1 2 3 | = if font is bold answer here

    Example if number 2 (column D Row 1 is bold and number 3 Column H Row 1 is bold then the answer should be 6

    but I want to do this for every row, auto filling as you bold the numbers if it's possible?

    Sorry I can't post the excel file because it's got accounts etc in it

    regards

    Graham

  7. #7
    Registered User
    Join Date
    08-27-2012
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: multiply if bold

    Idk how you would be able to autofill just changing whether its bold or not, but someone else might know the answer to that question. I could write something that runs after all of it has been bolded, however. If you could just take random data without names or anything and post it as an example, it makes it easier for I or someone else to write something for it. If you can post just a 6-8 line workbook with dummy numbers then I'll write somethin that should be able to help.

  8. #8
    Registered User
    Join Date
    06-18-2012
    Location
    South Yorkshire
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: multiply if bold

    Hi Oredigger90,

    I've attached the file, see what you think?
    Book1.xlsx
    Graham

  9. #9
    Registered User
    Join Date
    08-27-2012
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: multiply if bold

    So this code will work specifically for that worksheet. If you understand basic VBA stuff, you should be able to make any modifications that you need if your format is any different. It's longer than I would like, but I don't yet know how to specify multiple ranges in the start of a For Loop. But here you go! Make sure to mark SOLVED if this works for you and click on my star to increase my reputation! lol

    Please Login or Register  to view this content.

  10. #10
    Registered User
    Join Date
    06-18-2012
    Location
    South Yorkshire
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: multiply if bold

    Hi Oredigger90,

    That's awesome mate!!! it's sorted thank you very much!!!!

    Graham

  11. #11
    Registered User
    Join Date
    08-27-2012
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: multiply if bold

    No problem, you ever need more help with another spreadsheet Personal Message me with the title of the Thread in it. I started learning VBA a couple weeks ago and want to increase my knowledge as fast as possible for work reasons. Hope it works well for you!

  12. #12
    Registered User
    Join Date
    06-18-2012
    Location
    South Yorkshire
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: multiply if bold

    Will do mate and once again thankyou.

    And wish you luck with the VBA.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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