+ Reply to Thread
Results 1 to 4 of 4

highlight specific columns in a for loop

  1. 03-05-2017, 02:15 PM #1
    MarkFltc
    MarkFltc is offline
    Registered User
    Join Date
    01-17-2017
    Location
    NEW JERSEY
    MS-Off Ver
    10.0
    Posts
    28

    highlight specific columns in a for loop

    Hi,

    i have this code which highlights the entire row if a cell contains a certain value.

    Please Login or Register  to view this content.
    how do i get it to highlight only columns A through S in that row?
    Reply With QuoteRegister To Reply
  2. 03-05-2017, 02:35 PM #2
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: highlight specific columns in a for loop

    Try this code
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  3. 03-05-2017, 03:03 PM #3
    MarkFltc
    MarkFltc is offline
    Registered User
    Join Date
    01-17-2017
    Location
    NEW JERSEY
    MS-Off Ver
    10.0
    Posts
    28

    Re: highlight specific columns in a for loop

    thanks! Worked!

    would you be able to show me how to do the same thing in this type of loop?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 03-05-2017, 03:52 PM #4
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: highlight specific columns in a for loop

    May be
    Please Login or Register  to view this content.
    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. Highlight the entire row for the specific criteria given in the columns
    By aman2059 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-17-2016, 03:26 PM
  2. [SOLVED] Highlight Entire Row if Any Cell is Blank in One or More Specific Columns
    By ptjameso in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-09-2015, 01:17 PM
  3. Highlight entire Row of Data to a sepcific Range of Columns (With-in a Loop)
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-05-2015, 04:45 PM
  4. Highlight entire Row of Data to a sepcific Range of Columns (With-in a Loop)
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2015, 02:56 PM
  5. [SOLVED] VBA - Loop - Compare data of two columns & copy unmatched to specific place one by one
    By laiqkhan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-22-2014, 01:07 AM
  6. VBA to create specific named ranges and repeating process (Loop?) across columns
    By vinothj86 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-30-2012, 05:01 AM
  7. Macro or VBA code to highlight specific named columns in a column chart
    By glenp99 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-03-2010, 05:12 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