hi-lighting a row

[topgun-usaf]

Data entry would be so much easier for me if I new how to do the following:

How do I hi-light a row and retain the hi-lighted row while filling in data in the cells across the row from left to right.

When moving off the row the hi-lighting stops.

Thank you to anybody who can help.

 

[VoG]

Select the whole sheet, Format > Conditional Format, select Formula Is and enter the formula

=row()=cell("row")

then select a suitable fill color. 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

 

[XL&ME]

Vog,

Is it possible to convert your directions into a macro in the personal.xla? Then a user could click a button and have the row highlighter work in whatever workbook that want.

 

[VoG]

I don't believe that is possible. The event code needs to be in the active workbook.

 

[XL&ME]

VoG,

Thanks for letting me know that it is not possible. I am not familiar with VBA, but did play around with the macro recorder, plus making trial and error changes to the macro recorder code. Of course none of my attempts worked.

 

[mrul]

Auto Serial Number

I am a new Excel user. I want to know how I can create Auto serial Number.
I have another problem, how I can create auto Ascending. Pls Let me Know that.


Thanks

mrul

 

[XL&ME]

Another way to enter data on a highlighted row is to use the shift key + the spacebar to highlgiht the row. Then use the tab key or enter key to move the cursor to the right. To move to the left, use the shift key + the tab key.