How to Highlight Auto the Active Row and Column in a Data Range | Excel Tips and Tricks #11
Join this channel to get access to perks:
/ @vireakphou
#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 : • How to create Bar Code in excel | Exc...
How to turn off Protected View in Excel | Excel Tips and Tricks #09 : • How to turn off Protected View in Exc...
How to insert pages number in excel | Excel Tips and Tricks #08 : • How to insert pages number in excel |...
How to make 10000 numbering in excel in 3 second | Excel Tips and Tricks : • How to make 10000 numbering in excel ...
How to manage overflow text in excel | Excel Tips and Tricks : • How to manage overflow text in excel ...
How to lock some cell with password in excel | Excel Tips and Tricks : • How to lock some cell with password i...
How to change columns heading from letters to Number in excel : • How to change columns heading from le...
How to show or hide formula bar on excel : • How to show or hide formula bar on ex...
How to show battery percent on iPhone : • How to show battery percent on iPhone
How to install Khmer keyboard completely on iPhone latest : • How to install Khmer keyboard complet...
How to show easy touch on iPhone iOS 14 | iPhone tips : • How to show easy touch on iPhone iOS ...
How to change youtube cover image | YoutubeTips & Tricks : • How to change youtube cover image | ...
How to customize widget and reset iOS 14 home screen : • How to customize widget and reset iOS...
How to record screen on iPhone without any app : • How to record screen on iPhone withou...
How to check duration of season ends on mobile legends : • How to check duration of season ends ...
New Updated | How to turn on speed boost in Mobile Legends : • New Updated | How to turn on speed bo...
How to change youtube light mode to dark mode on phone : • How to change youtube light mode to d...
Check out my popular playlist :
Excel tutorials 2020 : • Excel tutorials 2020
Blogger tips and tricks : • Blogger tips and tricks
Google Form : • Google Form
General Knowledge: • General Knowlegde
Technology tips and tricks: • Technology tips and tricks
Game : • Game tips and tricks
Computer tips and tricks : • Computer tips and tricks
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 !
~-~~-~~~-~~-~
Please watch: "How to lock some cell with password in excel | Excel Tips and Tricks #05 "
• How to lock some cell with password i...
~-~~-~~~-~~-~