"Some time ago, I was experimenting with automatic row highlighting using VBA and thought a separate post might be in order just in case the previous comments got missed.
'Using the Visual Basic Editor, place the following code in ThisWorkbook.
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Application.ScreenUpdating = True
End Sub
'Then, select your range with the mouse and open Conditional Formatting from the Format menu to enter this formula.
=CELL("row")=ROW()
'This is how it looks.
'Quite simple and easy to remember. (The screen flickers a bit with larger files, it still seems to work without problems).
'Ivan F Moala of the famed Xcel Files was kind enough to show me a good alternative. It does have some drawbacks but the highlighting factor itself is improved.
Note: It was also suggested to use =OR(CELL("row")=ROW(), CELL("col")=COLUMN()) to get both active row and column on my Japanese site. The choice is yours ;-)"
No comments:
Post a Comment