+ Reply to Thread
Results 1 to 4 of 4

Macro - To change fonts when their values change

  1. 07-04-2012, 09:13 PM #1
    mgs
    mgs is offline
    Registered User
    Join Date
    02-20-2011
    Location
    Queensland, Australia
    MS-Off Ver
    Office 365
    Posts
    71

    Macro - To change fonts when their values change

    My question relates to cells B10:L18 in a worksheet.


    What macro will:

    Automatically change the fonts to Bold Black, whenever their values change.
    Then return them to their original settings and repeat the above (start another cycle), whenever fresh data is entered.


    Fresh data is entered in another sheet.


    I’m using Excel 2010
    mgs
    Last edited by mgs; 07-05-2012 at 04:05 AM.
    Reply With QuoteRegister To Reply
  2. 07-04-2012, 09:27 PM #2
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro - To change fonts when their values change

    Try the Worksheet_Change and the Worksheet_SelectionChange events.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  3. 07-05-2012, 04:03 AM #3
    mgs
    mgs is offline
    Registered User
    Join Date
    02-20-2011
    Location
    Queensland, Australia
    MS-Off Ver
    Office 365
    Posts
    71

    Re: Macro - To change fonts when their values change

    Quote Originally Posted by xladept View Post
    Try the Worksheet_Change and the Worksheet_SelectionChange events.
    Thanks for your help, xladept - your suggestions steered me towards Worksheet_Calculation so I will wrestle with that...

    Cheers,
    mgs
    Reply With QuoteRegister To Reply
  4. 07-05-2012, 12:47 PM #4
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macro - To change fonts when their values change

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1