+ Reply to Thread
Results 1 to 7 of 7

Color change of complete row

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    96

    Color change of complete row

    Hi , i need a code in worksheet change ... when i select a cell eg in column L , the enitre row color changes to light red , and when i hit enter to go to the next row of column L , the next row color changes and the color of last row again come back to white ,,, and this goes on in whole column L selction.
    thanks

  2. #2
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: Color change of complete row

    try this
    Please Login or Register  to view this content.
    Last edited by Sean Thomas; 01-17-2014 at 08:30 AM. Reason: additional code
    Regards
    Sean

    Please add to my reputation if you think i helped
    (click on the star below the post)
    Mark threads as "Solved" if you have your answer
    (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code:
    [code] Your code here [code]
    Please supply a workbook containing example Data:
    It makes its easier to answer your problem & saves time!

  3. #3
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: Color change of complete row

    Hi -

    Try this one and let me know.
    Please Login or Register  to view this content.
    event
    Last edited by event21; 01-17-2014 at 08:05 AM. Reason: exclude row 3

  4. #4
    Registered User
    Join Date
    04-11-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    96

    Re: Color change of complete row

    code works perfectly but one more thing , i want the entire row 3 interior color must remain blue , it will not change, want to b permannent

  5. #5
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: Color change of complete row

    Hi -

    I have edited my post to exclude row 3.

    PS: you did not mentioned which code you have tried.

    event

  6. #6
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: Color change of complete row

    Hi,
    i have updated my code to keep row 3 blue

  7. #7
    Registered User
    Join Date
    04-11-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    96

    Re: Color change of complete row

    thanks , now the code works perfectly

+ 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. Replies: 4
    Last Post: 03-21-2012, 01:12 AM
  2. find to add color in the complete row of match
    By pete34 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2008, 03:09 PM
  3. Format cell color on change, how to change the color in other columns as well?
    By s80NL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-28-2007, 09:24 PM
  4. Changing the text color of a complete row ...
    By Rob Keel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-13-2005, 10:05 AM
  5. Change complete worksheet to degrees
    By Scrungie in forum Excel General
    Replies: 2
    Last Post: 09-12-2005, 02:05 PM

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