In the New Formatting Rule dialog box, select “Use a formula to determine which cells to format”.Click on Conditional Formatting and then click on New Rule.Select the data set in which you to highlight the active row/column.Here are the steps to highlight the active row and column on selection: Now let’s see how to create this functionality in Excel.ĭownload the Example File Highlight the Active Row and Column in Excel This can be helpful when you’re working with a large dataset and can also be used in Excel Dashboards. In the above example, as soon as you select a cell, you can see that the row and column also get highlighted. Let me first show you what we are trying to achieve. In case you prefer written instructions, below is a tutorial with exact steps on how to do it. It will save me some time and help the readers too.īelow is a video where I show how to highlight the active row and column in Excel. So I decided to create a tutorial and a video on it. One of the Excel queries I often get is – “How to highlight the Active Row and Column in a data range?”
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |