Excel, highlight cells in which you are typing, for visability.

G

Guest

I would love it if Excel highlighted the cell I was working in, instead of
just making the border bolder. I would also like to choose my own color of
highlight.

This would make it so easy on my eyes and easier to find the cell when
looking back and forth from data to computer screen.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...8-efd3f7e15446&dg=microsoft.public.excel.misc
 
O

Otto Moehrbach

You can do that now with the following macro:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = 0
Target.Interior.ColorIndex = 36
End Sub
Note that this macro must be placed in the sheet module of every sheet you
want this to work on. To access that module, right-click on the sheet tab,
select View Code, and paste this macro into that module. "X" out of the
module to return to your sheet. Change the number of the color to suit.
HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top