Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel, highlight cells in which you are typing, for visability.

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/comm...lic.excel.misc
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,090
Default Excel, highlight cells in which you are typing, for visability.

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
"skbenny" wrote in message
...
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/comm...lic.excel.misc



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Groups of cells between workbooks vnacj-joe Excel Discussion (Misc queries) 4 June 14th 07 05:18 PM
Excel truncated my cells when copying, how to avoid?? bxc2739 Excel Discussion (Misc queries) 0 March 17th 06 04:40 PM
Maintain proper links when Excel cells are moved Excelnovice Excel Discussion (Misc queries) 0 February 19th 06 06:17 PM
Weird question on filling in typing in excel bwall Excel Discussion (Misc queries) 3 September 6th 05 09:24 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM


All times are GMT +1. The time now is 05:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"