+ Reply to Thread
Results 1 to 3 of 3

Highlight Active Row and Column in Excel (Based on Cell Selection)

  1. 09-18-2020, 08:46 AM #1
    atthershabbir
    atthershabbir is offline
    Registered User
    Join Date
    03-27-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    44

    Highlight Active Row and Column in Excel (Based on Cell Selection)

    Hi
    I work with data sets daily with different files, so need some code to Highlight Active Row and column in excel.
    I found a code online which i hv pasted below and have created a Macro in my Personal workbook so i can use in any file.
    So everytime a new Excel file is opened i run the Macro from Personal Workbook and the Rows n Columns are selected but as i change the cell i have to press F9 everytime. Is there any solution to that, so that as i move the cell the rows n columns r selected dynamically without pressing F9 everytime.
    One more thing i dont want this feature on all the excel files i work, as other normal files i wont need this funtion... Hoping to get a reply.


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 09-18-2020, 09:41 AM #2
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Highlight Active Row and Column in Excel (Based on Cell Selection)

    Hi.

    What you are after are cross hairs.

    You will need two conditional format rules and this code:

    =AND(CELL("col")=CELL("col",A1),CELL("row")=CELL("row",A1)) for Yellow

    =OR(CELL("col")=COLUMN(A1),CELL("row")=ROW(A1)) for Grey


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 09-18-2020 at 09:47 AM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.
    Reply With QuoteRegister To Reply
  3. 09-23-2020, 10:45 AM #3
    atthershabbir
    atthershabbir is offline
    Registered User
    Join Date
    03-27-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: Highlight Active Row and Column in Excel (Based on Cell Selection)

    Thanks for your reply brother.. i got it and can be used in single file only..
    is it even possible for this feature to work on Personal workbook?.
    Your reply would be helpful.
    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. [SOLVED] Highlight Rules Based on Selection in Cell
    By crazyforexcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-28-2019, 08:14 AM
  2. [SOLVED] Highlight Column A Cell based on active row
    By BG1983 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-16-2018, 01:49 PM
  3. [SOLVED] highlight selection based on dropdown selection and value in answer column
    By madhatter40 in forum Excel General
    Replies: 1
    Last Post: 07-03-2013, 10:50 AM
  4. Highlight Row & Column of Active cell in large spreadsheets
    By chrisb84 in forum Excel General
    Replies: 5
    Last Post: 04-09-2013, 05:29 PM
  5. [SOLVED] Highlight Row of Active Cell on Worksheet Selection Change
    By adam2308 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-03-2012, 02:23 AM
  6. Highlight the row and column of the active cell
    By ictodd in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-20-2011, 09:26 PM
  7. [SOLVED] How to set highlight for the column&row header of the active cell
    By Jasmine in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-14-2006, 11:40 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