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




About this tutorial:

Video duration: 00:09:34
One of the Excel queries I often get is – “How to highlight the Active Row and Column in a data range?”

Read more about the tutorial:

Download file:

So I decided to crate this video and show how to do this,

In this video, I will show you how to use Excel formula and conditional formatting to instanly highlight active row and column as soon as the user makes a selection or changes the selection.

To make sure this is dynamic, I have used…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

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

    L. M.

    (June 25, 2020 - 5:47 am)

    =or(cell("col")=column(),cell("row")=row())

    Babu Nayagam

    (June 25, 2020 - 5:47 am)

    Very nicely explained. Loved that thanks

    sadashiv shende

    (June 25, 2020 - 5:47 am)

    how to do same in google sheet ?

    Brandon Garcilazo

    (June 25, 2020 - 5:47 am)

    Thanks so much for this – very helpful. How can I modify this to highlight more than 1 row or column when a RANGE of cells is selected? For example, if cell H4 is currently selected, column H and Row 4 are highlighted. How about if I selected cell RANGE H4:H6 – Is there a way to modify this such that Column H will be highlighted, as well rows 4, 5, and 6?

    thezionzion

    (June 25, 2020 - 5:47 am)

    Awesome and Informative! Thank you!

    Tony Shore

    (June 25, 2020 - 5:47 am)

    BRILLANT! Concise and No Nonsense tutorial that got the job done for me and also allowed me to modify the formula to have only a row as well as change the cell range. WELL DONE Ace!

    Chirag Bhardwaj

    (June 25, 2020 - 5:47 am)

    Thanks for the video – my only question is that whenever I use the keyboard to shift cells, it selects all cells instead of just changing them – is there any way to remove that?

    KCS `

    (June 25, 2020 - 5:47 am)

    Every day I am learning new tricks from your videos – very productive in real-time scenarios. A big thanks to all the Hands and Minds of these videos.

    Conya Sarrels

    (June 25, 2020 - 5:47 am)

    I have a script that pulls data from the database with a select statement, and populates the sheets in a workbook. How can I set this to work in each tab?

    Sandra Bythe

    (June 25, 2020 - 5:47 am)

    Amazing that this isn't standard functionality in Excel

    Jessica Binnie

    (June 25, 2020 - 5:47 am)

    How can you change this for MAC excel which doesn't allow the dropdown selection of "worksheet" in VBA?

    Kaho

    (June 25, 2020 - 5:47 am)

    =OR(CELL("col")=COLUMN(),CELL("row")=ROW()

    Sumama Ai

    (June 25, 2020 - 5:47 am)

    after this sheet is working slow

    huzaifa nasim

    (June 25, 2020 - 5:47 am)

    i have a concern after adding this how remove it

    Sarfraz Hussain Khan

    (June 25, 2020 - 5:47 am)

    its a great escape brother, but I am unable to copy and paste anything due to automatic calculation. and it takes so much time because i have many formulas in the sheet. please help,

    Waqar Hussain

    (June 25, 2020 - 5:47 am)

    its like a life savior bro. Great help lots of likes to your work, Can you please msg me I have many good questions that I am sure you have answers. It will help others too.

    MrElliottjc

    (June 25, 2020 - 5:47 am)

    Simply Brilliant!

    MrVikutaa

    (June 25, 2020 - 5:47 am)

    How to overwrite cells with existing fill on it? I have this issues as some of my cells are alrdy highlighted to represent some sort of status. Can anyone help?

    محمد حلمي

    (June 25, 2020 - 5:47 am)

    Cool Trick Thank You

    jovany cruz

    (June 25, 2020 - 5:47 am)

    try it
    =OR(CELL("col")=COLUMN(),CELL("row")=ROW())

    Anand Solanki

    (June 25, 2020 - 5:47 am)

    I have query that do we have to save this file as Macro Enable File "highlight the Active Row and Column in a data range".

    Gabriela Hermaya

    (June 25, 2020 - 5:47 am)

    Thank you dear! Clear, simple and useful video!

    June Di Franco

    (June 25, 2020 - 5:47 am)

    What if this does not work? What could I be doing wrong?

    wissam yaghi

    (June 25, 2020 - 5:47 am)

    Very nice

    Alvaro Romero

    (June 25, 2020 - 5:47 am)

    You are going to be my God since today!

    Fahad Ahmed

    (June 25, 2020 - 5:47 am)

    Thanks, buddy you made my day. you are a pro

    Nitesh Prabhu

    (June 25, 2020 - 5:47 am)

    Have you tried using a volatile function in your conditional formatting formula to automatically recalculate, such as using "=if(today(),formula)"?
    I think this should work without VBA

    Diasse Tefle

    (June 25, 2020 - 5:47 am)

    It's very useful, thanks a lot for this tutorial.

    FPQ

    (June 25, 2020 - 5:47 am)

    Perfect! Thanks!

    Andrew Mulhearn

    (June 25, 2020 - 5:47 am)

    Excellent addition to my sheets! thanks for showing us. I do have one question… is there any way to get the colors to stop at the intersection point?

    Heath Stapleford

    (June 25, 2020 - 5:47 am)

    THIS IS AWESOME!!!! Financial auditor here and my spreadsheet are gigantic. This is literally going to save me multiple hours a week probably.

    Phillip Bailey

    (June 25, 2020 - 5:47 am)

    Thanks a million! The earlier versions of excel seemed to be better at this or maybe it's just my eyes getting older. Works fantastic!

    Joëlle Emond

    (June 25, 2020 - 5:47 am)

    Hi! Thank you very much. Your explanations were clear and I was able to do it. Unfortunately, it is not as helpful as I thought it would be for our purpose. Would you please be able to help me find the information on how to undo it? Thank you!

    Amanpartap Singh

    (June 25, 2020 - 5:47 am)

    Excellent!

    Said Elnaffar

    (June 25, 2020 - 5:47 am)

    Very useful — thanks!

    Jože Mikec

    (June 25, 2020 - 5:47 am)

    This video deserves a big Like 😀

    Andrew

    (June 25, 2020 - 5:47 am)

    This is so elegant. Wonderful 🙂

    Milan Kumar

    (June 25, 2020 - 5:47 am)

    But Im not able to Change Font And Size when formatting pls reply how can i do this . If we change font size then it will be very clear to read

    freazingflame

    (June 25, 2020 - 5:47 am)

    works great. I really need this when looking through massive amounts of data.

    Thank you, brother.

Leave a Reply

Your email address will not be published. Required fields are marked *