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 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 - [ Ссылка ]
Paid Online Training - [ Ссылка ]
Best Excel Books: [ Ссылка ]
⚙️ Gear I Recommend:
Camera - [ Ссылка ]
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - [ Ссылка ]
Wireless Mic: [ Ссылка ]
Lighting - [ Ссылка ]
Subscribe to get awesome Excel Tips every week: [ Ссылка ]
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
