+ Reply to Thread
Results 1 to 3 of 3

highlighting the active row/column

  1. #1
    Registered User
    Join Date
    06-27-2019
    Location
    UK
    MS-Off Ver
    MS OFFICE 2016
    Posts
    24

    Lightbulb highlighting the active row/column

    Hi Guys,

    Could you please help with the below.
    I'm trying to find a way of highlighting active rows including those with the same corresponding values. In this case, if my cursor is selecting a number in a row with Mike's name I would like the entire row and column heading (within the table), to be highlighted in orange. In addition I would also like other rows with the text Mike to be highlighted in light grey.

    Please find the file attached.

    Thanks Chris
    Attached Files Attached Files
    Last edited by Chris220; 07-11-2019 at 05:13 AM.

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: highlighting the active row/column

    My approach to this is usually to use a selection change event to plug the details of the active cell into cells that will be on a hidden sheet. You can use something like the following for the table in Example 1:

    Please Login or Register  to view this content.
    You can then use the cells on your hidden sheet as easy references to create the conditional formatting rules that you're after. For instance, I used the following for the blue activecell highlight in the attachment:

    =AND(ROW(A1)=HideMe!$B$1,COLUMN(A1)=HideMe!$B$2)

    Craft the CF rules you want, hide the HideMe sheet, and you're good to go. For further details, take a look at the attachment, where I approximated your request for Example 1:
    If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".

    If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
    https://www.excelforum.com/the-water...ke-thread.html

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: highlighting the active row/column

    CAntosh provided a very nice solution, I am simply providing an alternative that does not rely on hidden sheets (though I prefer his idea to be honest).

    Please Login or Register  to view this content.
    You could of course make this a worksheet selection change event also

    PS I ignored the darker gray and the blue in the example... but that can be added if it was meant to actually look like that
    Last edited by Arkadi; 07-09-2019 at 11:23 AM.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

+ 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: 22
    Last Post: 01-26-2016, 07:43 AM
  2. Highlighting row and column of active cell (Excel 2010)
    By Smiffy3594 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2015, 11:44 AM
  3. Highlighting Active Cell/Column/Row Problem
    By Statto in forum Excel General
    Replies: 1
    Last Post: 10-18-2014, 12:08 PM
  4. Highlighting duplicate values in a column in conjunction with active cell
    By Brontosaurus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-03-2014, 01:11 PM
  5. Highlighting Active Cell
    By TheSeal in forum Excel General
    Replies: 2
    Last Post: 07-20-2007, 04:06 AM
  6. Highlighting an active cell
    By pjy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-02-2006, 12:40 PM
  7. Highlighting The Active Cell
    By Pelham in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2006, 10:00 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1