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 !
