How to Highlight Active Row and Column in Excel (Based on Cell Selection)|Advance Excel Tutorial
One of the Excel queries I often get is – “How to highlight the Active Row and Column in a data range?”
Introduction to Pivot Tables, Charts, and Dashboards in Excel | Interactive Excel Dashboards • Pivot Tables Introduction, Charts, and Das...
Protect Different Ranges with Different Password & Break EXCEL sheet Password Without using Software • Protect Different Ranges with Different Pa...
10 Things you can do Easily in Excel under 10 Minutes • 10 Things you can do Easily in Excel under...
How to work with multiple users on an Excel worksheet • How to work with multiple users on an Exce...
Import data From the web into Excel • How to Import data From the web into Excel
How to search multiple files in a folder in Tamil tutorial • How to search multiple files in a folder i...
How to compare two columns in Excel for matches and differences in • How to compare two columns in Excel for ma...
How to pull the date using Index,Match and vlookup Function in Excel tutorial • How to pull the date using Index,Match & v...
How to find Common value in Excel Tutorial in Tamil • How to find Common value duplicate value ...
Most Important shortcuts and Join the Data from two cell, Split multi data in a cell • Most Important shortcuts and Join the Data...
How to Create Chart or Graph in Ms office and Power point Tutorial • How to Create Chart or Graph in Ms office ...
Auto Increment serial Number , Shortcut for addition tutorial • Auto Increment serial Number , Shortcut fo...
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.
=ROW()=CELL("row")
=COLUMN()=CELL("col")
Application.ScreenUpdating = True
#ttamiltechnology
@ttamiltechnology
#excel