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

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: https://trumpexcel.com/highlight-active-row-column-excel/

Download file: https://www.dropbox.com/s/jxcu38sm4brip8z/Highlight-the-Active-Row-and-Column.xlsm?dl=0

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 a very simple VBA code as well (the worksheet change event).

Useful Notes:
-- This method would not impact any formatting/highlighting you have done manually to the cells.
-- Conditional formatting is volatile. If you use it on very large datasets, it may lead to a slow workbook.
-- The VBA code used above would refresh the workbook every time there is a change in selection.
-- CELL Function is available in Excel 2007 and above version for Windows and Excel 2011 and above for Mac. In case you’re using an older version, use this technique by Chandoo.


Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/

⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

Видео Highlight Active Row and Column in Excel (Based on Cell Selection) канала TrumpExcel