+ Reply to Thread
Results 1 to 2 of 2

Highlight row and/or column when cell is selected

  1. #1
    Forum Contributor
    Join Date
    05-23-2014
    Location
    Fredericia, Denmark
    MS-Off Ver
    Windows Office 2013, Excel 10
    Posts
    139

    Highlight row and/or column when cell is selected

    I found this code online, to shade both row and column of any cell, when selected:

    HTML Code: 
    However, the problem is that it clears out any previous shaded cells when another cell is selected. Can this script be adjusted to leave previous shadings alone when navigating among cells?

    Thanks. David

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Highlight row and/or column when cell is selected

    This should work.
    Please Login or Register  to view this content.
    BSB

+ 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. Highlighter: If cell is selected, highlight row 3 same column
    By jokris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2017, 10:35 AM
  2. [SOLVED] Highlighter: If cell is selected, highlight row 3 same column
    By jokris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2017, 10:30 AM
  3. Highlight row and column of selected cell
    By SwissExcel in forum Excel General
    Replies: 8
    Last Post: 09-14-2016, 06:46 AM
  4. [SOLVED] Ability to auto-highlight entire row and column of selected cell
    By stephenminton in forum Excel General
    Replies: 22
    Last Post: 04-02-2014, 02:35 PM
  5. Defining a range to highlight column and row in line with selected cell
    By ACM2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2012, 11:13 PM
  6. Replies: 1
    Last Post: 05-22-2006, 05:10 AM
  7. How to highlight row and column of the selected cell
    By Row_Column_Highlight in forum Excel General
    Replies: 2
    Last Post: 02-27-2005, 07:06 PM

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