Highlight Active Cell's Row and Column in Excel│ComTutor Excel Trick

▬▬▬▬▬▬▬▬▬ஜ۩۞۩ஜ▬▬▬▬▬▬▬▬
▓▓▓▒▒▒░░░ Open This Description ░░░▒▒▒▓▓▓
▬▬▬▬▬▬▬▬▬ஜ۩۞۩ஜ▬▬▬▬▬▬▬▬
Highlight the Active Row and Column in a Data Range in Excel Or How to highlight the active row, column, or both using VBA and conditional formatting

In a complex sheet with lots of data, it's sometimes helpful if you can highlight the active cell's corresponding row or column — or both. Doing so seems like a complex problem, but it's easier than you might think. I'll use VBA's ActiveCell property to return the row and column of the active cell. Then, I'll build a conditional format rule that relies on that value for formatting.

Here are the steps to highlight the active row and column on selection:
Select the data set in which you to highlight the active row/column.
Go to the Home tab.
Click on Conditional Formatting and then click on New Rule.
In the New Formatting Rule dialog box, select “Use a formula to determine which cells to format”.
In the Rule Description field, enter the formula: =OR(CELL(“col”)=COLUMN(),CELL(“row”)=ROW())
Click on the Format button and specify the formatting (the color in which you want the row/column highlighted).
Click OK.
The above steps have taken care of highlighting the active row and active column (with the same color) whenever there is a selection change event.

However, to make this work, you need to place a simple VBA code in the backend.
How to Highlight a Row in Excel Using Conditional Formatting

=======**************Here is the VBA code that you can copy and paste**************=======

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Application.CutCopyMode = False Then
Application.Calculate
End If
End Sub

=============================================================================

The above VBA code is run whenever there is a selection change in the worksheet. It forces the workbook to recalculate, which then forces the conditional formatting to highlight the active row and the active column. Normally (without any VBA code) a worksheet refreshes only when there is a change in it

Download VBA Text:- https://drive.google.com/uc?export=download&id=1YI20NbIHe5xvNVW6CKGKZuklzhnqIfnm

Download Excel Sheet:- https://drive.google.com/uc?export=download&id=1-evU1iuOijwifNEBgkB7ZlkVfkvo_0dx

Highlighting the active cell's row or column will help you find the data you need quicker, and implementing the technique is easier than you might think.

ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है।

आप हमारे चैनल को Subscribe करे।
https://www.youtube.com/channel/UC2k9JH38F3byw92XaFuoPuw?sub_confirmation=1

फेसबुक पर पसंद करने के लिए क्लिक करें
https://www.facebook.com/Comtutor4u/

ट्विटर पर फॉलो करने के लिए क्लिक करे
https://twitter.com/Comtutor4u

Видео Highlight Active Cell's Row and Column in Excel│ComTutor Excel Trick канала ComTutor