please help

[oscar herrera]

HOW DO I COLOR THE WRAPPING OF A CELL WHERE ENTRING DATA ? work with many
numbers. some times is hard to locate where one is entering the data.

 

[Kevin B]

Press Alt + F11 to open the Visual Basic Editor and in the PROJECT window,
double click on the ThisWorkbook object.

In the module window, drop down the combo box selections where it says
GENERAL ans select Workbook, and from the DECLARATIONS combo box select
SheetSelectionChange

In the module add the following lines of code

Cells.Interior.ColorIndex = xlNone
Target.Interior.ColorIndex = 6

When you're finished the completed sub should look like this:

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)

Cells.Interior.ColorIndex = xlNone
Target.Interior.ColorIndex = 6

End Sub

Click FILE in the menu and select CLOSE AND RETURN TO EXCEL and then save
the workbook.

You might have to close and reopen the workbook, but maybe not. The cell
pointer is highlighted yellow so you can easily locate the current cell
visually.

Hope this helps..

 

[Jim Thomlinson]

Check out this link...

http://www.cpearson.com/excel/excelM.htm#HighlightActiveCell

 

[Chip Pearson]

You might find my RowLiner add-in useful. See
http://www.cpearson.com/Excel/rowliner.htm for details and free download.

--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)