Highlight vertical and horizontal rows

[Collective]

Could anyone tell me if there is a way of highlighting the column and rows of a selected cell?

For example making a cross on the screen with the cell selected as the center point and the cross moving with each new cell selected.

Thanks!

 

[JoeMo]

Could anyone tell me if there is a way of highlighting the column and rows of a selected cell?

For example making a cross on the screen with the cell selected as the center point and the cross moving with each new cell selected.

Thanks!

Can be done with VBA.

 

[Gilliam]

this procedure will work however, it does clear ALL cell highlights before each use

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Cells.Interior.ColorIndex = xlNone
    Target.EntireColumn.Interior.ColorIndex = 6
    Target.EntireRow.Interior.ColorIndex = 6
End Sub

not sure if that's okay with you :s

 

[WarPigl3t]

I would start by recording a macro of you selecting a cell, then select an entire row, then select an entire column. Then end the macro recording. That way you have the syntax of how you need to program the code. Then go to edit macros and change the select row code and the select column code. You can use variables to capture the column and row of the selected cell, then use those same variables to designate the select row and select column lines of code. Easy.you barely even have to write any code. The record macro does most of the work for you.

 

[VoG]

Select the range, Conditional formatting:

=OR(row()=cell("row"),column=cell("Col")
and set a fill colour

Then right click the sheet tab, select View Code and paste in

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.ScreenUpdating = True
End Sub