Trying to get this solved but strangely it don't work.
I am using Excel 2013.
Ok, i've found 2 solutions so far.
The first one (which is not good for me)
is easy, but the problem with it is that it removes all other colours from the worksheet when working, i've came along some posts where you can actually store your formatting on a seperate sheet, but no this aint gonna be my solution.
The second one.
Looks neat, could use it, it just don't work :(
Here's what i've done:
-Created new name in name manager: ActiveRow then made it refer to =1
-Applied conditional formatting to the whole sheet: =ROW(A1)=activerow
-Then added the code to Sheet 1:
When i click around the sheet i notice some loading, but the highlighting won't happen.
Could you take a look at my issue please? Any other solutions are welcome.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
.Name = "activerow"
.RefersToR1C1 = "=" & ActiveCell.Row
This question generated 15 answers. To proceed to the answers, click here.
This thread is current as of April 28, 2015.