Rhonda,
This will change the interior color of the activecell to red whenever
the selection changes, regardless of how the cell was selected. Only
problem, it removes the interior color of all the other cells every
time to prevent leaving a trail of red cells. That means if you have
some other interior colors on your sheet, you will lose them. If you
want to use it, copy this code and paste it into the worksheet's module
(right-click on the worksheet's tab, select view code, and paste it in
there). James

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
ActiveCell.Interior.ColorIndex = 3
End Sub

Rhonda wrote:
Is there a way to click on any cell either with tab or arrow key and that
cell automatically highlights in a color such as red? This is requested so
that if a person is working in a long spreadsheet with alot of statistics,
they will be able to see the cell that they have selected as it will be
highlights. I tried to create a macro but could not figure out how to make
it automatically highlight a cell when selected throughout the spreadsheet.
Any help or suggestions will be greatly appreciated? Any other solutions
will be greatly appreciated!