Excel - Color Active Row where editing.
Useful Excel macros
Color Active Row in Excel where Editing.
If you have
tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate
those tasks. A macro is an action or a set of actions that you can run As many
times as you want. When you create a macro, you are recording your mouse Clicks
and keystrokes. After you create a macro, you can edit it to make minor Changes
to the way it works.
Suppose that you always work on
large files and even you are freezing header, still you need some highlighter
which guide you where your courser is…
One of the great macro which
can help you is below given. This will highlight the row where are present in
excel.
Create
a macro.
1. In View Tab. See macros
written in the end
2. Select that
3. You will see View macro
4. Click view macros
5. enter a name for the macro
in macro name:
6. and then click create to start writing.
7. Replace below given text with…
8. With this code.
Private Sub Change_current_row_color(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
Application.ScreenUpdating = False
Cells.Interior.ColorIndex = 0
With Target
.EntireRow.Interior.ColorIndex = 37
.EntireColumn.Interior.ColorIndex = 24
End With
Application.ScreenUpdating = True
End Sub
9. Close macro page and save.
|
Name |
City |
State |
Country |
|
Ramesh |
Indore |
Madya
Pradesh |
India |
|
Vijay |
Delhi |
Delhi |
India |
|
Rakesh |
Varanasi |
Uttar
Pradesh |
India |
|
Rajesh |
Pune |
Maharashtra |
India |
|
Anuj |
Ahmedabad |
Gujarat |
India |
|
Prakhar |
Mumbai |
Maharashtra |
India |
|
Srikanth |
Hyderabad |
Telangana |
India |
10. And you are done.
I hope you like this blog. Please visit our web site to see what the services we offer.
Website : delvesolutions.net
