+ Reply to Thread
Results 1 to 2 of 2

Highlight a selected row

  1. 03-10-2010, 11:23 AM #1
    Barking_Mad is offline
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Highlight a selected row

    Hi,

    I have some code which highlights an entire row depending upon which row is selected:

    Please Login or Register  to view this content.
    This works nicely but has two problems.

    1) It removes all current cell formatting - which i would like to keep

    2) It highlights the entire row and not a range of cells (ie. A7:K1000)

    Could anyone help me modify this?

    Thanks
    Last edited by Barking_Mad; 03-10-2010 at 11:39 AM.
    Reply With QuoteRegister To Reply
  2. 03-10-2010, 11:41 AM #2
    Barking_Mad is offline
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Re: Highlight a selected row

    I've found that conditionally formatting the column headers with "TEXT CONTAINING" will override the removal of the original colour and stop the cell changing colour when selected. Bit of a pain and not ideal as I have about 12 headers.
    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)

Tags for this Thread

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