Differences

This shows you the differences between two versions of the page.

--- home_server:mswindows_notes [2025-03-18 Tue wk12 16:58] – [MS Excel Highlight Row or Column] baumkp
+++ home_server:mswindows_notes [2025-03-18 Tue wk12 17:10] (current) – [MS Excel Highlight Row or Column] baumkp
@@ Line 227: / Line 227: @@
 Use a VB macro.  Main down side to this is that it slows down the MSExcel performance
+++++VB Code 1|
+<code>
+'from https://www.exceldemy.com/learn-excel/highlight/row/
+Private Sub Worksheet_SelectionChange(ByVal Target As Range)
+  If Target.Cells.Count > 1 Then Exit Sub
+  Application.ScreenUpdating = False
+  'Clear the color of all cells
+  Cells.Interior.ColorIndex = 0
+  With Target
+    'Highlight row and column of the selected cell
+    .EntireRow.Interior.ColorIndex = 38  'or use RGB(200,200,200) to pick a colour
+    .EntireColumn.Interior.ColorIndex = 24
+  End With
+  Application.ScreenUpdating = True
+End Sub</code>
+++++
 ++++VB Code 2|
-<code>Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
+<code>'from https://www.howtoexcel.org/highlight-current-row-column/
+Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
 Static xRow
 Static xColumn