+ Reply to Thread
Results 1 to 3 of 3

change font color across row

  1. 09-10-2019, 10:16 AM #1
    Grilleman
    Grilleman is offline
    Forum Contributor
    Join Date
    04-11-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    245

    change font color across row

    Hi -

    I am wondering if there is a better way to effect a change to the font color and font weight (i.e. bold) across a row. See code below:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 09-10-2019, 10:25 AM #2
    torachan
    torachan is online now
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,303

    Re: change font color across row 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 09-10-2019, 10:26 AM #3
    Rick Rothstein
    Rick Rothstein is offline
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,408

    Re: change font color across row

    You can do an entire range all at once. Try replacing those 18 lines of code with this...
    Please Login or Register  to view this content.
    Last edited by Rick Rothstein; 09-10-2019 at 10:30 AM.
    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)

Similar Threads

  1. change cell color only if that cells font color is black and it's value is < 2000
    By randall78 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-05-2019, 05:23 PM
  2. Mouse rolls over to cell will change the tab color, font color and tp bold type
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-20-2013, 10:36 AM
  3. Change Font Color Based On Adjacent Cell Color
    By Zorro9758 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2013, 02:47 PM
  4. [SOLVED] Row font color to Match color of font in column D cells that will change IN DROP DOWN BOX.
    By NicksDad in forum Excel General
    Replies: 2
    Last Post: 02-04-2013, 02:00 PM
  5. Change font color based on font color of another cell
    By Ibyers in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2012, 09:36 AM
  6. change font color and font style in shape
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-05-2011, 10:05 AM

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