Highlighting a Row

F

Fufu

My Question is: as I data imput down a column(of multiple columns) can it
highlight the whole row so that I can be sure it is the right cell?
 
D

Don Guillett

right click sheet tab>view code>insert this>save
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlColorIndexNone
Target.EntireRow.Interior.ColorIndex = 36
End Sub
 
D

David McRitchie

You should see the row number and column letter highlighted,
but if you want to hightlight the row and column itself you can use
a macro, or a bit less of a problem if you already have shading
on cells would be to highlight the borders see Chip Pearson's
Row liner (addin)
http://www.cpearson.com/excel/RowLiner.htm
as with any macro solution you lose the ability to use Undo (Ctrl+Z) so
that is a very big trade off.
 
Top