Highlight Active Row and Column in Excel Based on Cell Selection

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=1sce8va1Yhg

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-acti... • Download file: https://www.dropbox.com/s/jxcu38sm4br... • 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/trumpexc... • Note: Some of these links here are affiliate links! • #Excel #ExcelTips #ExcelTutorial

#############################

New on site