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?

right click sheet tabview codeinsert thissave
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlColorIndexNone
Target.EntireRow.Interior.ColorIndex = 36
End Sub


--
Don Guillett
SalesAid Software

"Fufu" wrote in message
...
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?

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Fufu" wrote in message ...
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?