+ Reply to Thread
Results 1 to 2 of 2

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

Hybrid View

  1. #1
    skbenny
    Guest

    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. #2
    Otto Moehrbach
    Guest

    Re: 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" <[email protected]> wrote in message
    news:[email protected]...
    >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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1