Hey. 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 https://youtu.be/YSRuGR3q4uw?t=3m35s 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: Code: Private With ThisWorkbook.Names("activerow") .Name = "activerow" .RefersToR1C1 = "=" & ActiveCell.Row End With End Sub When i click around the sheet i notice some loading, but the highlighting won't happen.
This question generated 15 answers. To proceed to the answers, click here.
This thread is current as of April 28, 2015.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel