How to Highlight Auto the Active Row and Column in a Data Range

Join this channel to get access to perks: https://www.youtube.com/channel/UC3XH... #ExcelForBeginners #ExcelTipsAndTricks #ExcelTutorials2020 Hello my friend today I going to show you How to Highlight the Active Row and Column in a Data Range , If you not understand or need more video please drop comment below, I'll make the video for you. I hope my video tutorials is can help you, Please like and subscribe to get new video. Thank you for watching. This is introduction : How to Highlight the Active Row and Column in a Data Range 1- Select the data set in which you to highlight the active row/column. 2- Go to the Home tab. 3- Click on Conditional Formatting and then click on "New Rule". 4- In the New Formatting Rule dialog box, select “Use a formula to determine which cells to format”. 5- In the Rule Description field, enter the formula: =ROW()=CELL("row") 6- Click on the Format button and specify the formatting (the color in which you want the row/column highlighted). 7- Click OK, and Ok. ---------- 8- Click on Conditional Formatting and then click on "New Rule" Again. 9- Select “Use a formula to determine which cells to format” Again. 10- In the Rule Description field, enter the formula: =COLUMN()=CELL("col") 11- Click on the Format button and specify the formatting (the color in which you want the row/column highlighted). 12- Click OK, and Ok. ---------- 13- Right Click on sheet Name "Sheet1" 14- Click on View Code 15- Paste this code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.ScreenUpdating = True End Sub 16- Done. For more information about technology, software download, computer tip, game, video tutorial and Hollywood movies. Please go to my blog : https://bigboxsoftware.blogspot.com/ or https://bigboxsoftware.net/ Check out my previous video : - How to create Bar Code in excel | Excel Tips and Tricks #10 : https://youtu.be/zQgq0PJKHtA - How to turn off Protected View in Excel | Excel Tips and Tricks #09 : https://youtu.be/qXcPM7j51Tw - How to insert pages number in excel | Excel Tips and Tricks #08 : https://youtu.be/WWtjeiL51NQ - How to make 10000 numbering in excel in 3 second | Excel Tips and Tricks : https://youtu.be/5geXGLOkI_A - How to manage overflow text in excel | Excel Tips and Tricks : https://youtu.be/mHFp8Lvz66s Check out my popular playlist : - Excel tutorials 2020 : https://www.youtube.com/playlist?list... - Blogger tips and tricks : https://www.youtube.com/playlist?list... - Google Form : https://www.youtube.com/playlist?list... - General Knowledge: https://www.youtube.com/playlist?list... - Technology tips and tricks: https://www.youtube.com/playlist?list... - Game : https://www.youtube.com/playlist?list... Computer tips and tricks : https://www.youtube.com/playlist?list... If you would like to know something about computer tips track, Please drop comment below I will make video to reply you. Also do not forget to subscribe my channel to get new tips about computer, mac, phone, game, app … My channel is creating video refer to technology and video tutorial about computer for you upper 2 video a week. Thank you for your time, And hope all my video is helpful for you, Have a nice day !

Next Post Previous Post
No Comment
Add Comment
comment url