You could use the following in the worksheet module for the sheet you want
the highlight to occur in. However, as you move through the worksheet, the
active cell has its interior set to blue, while all the other cells in the
workbook have a white interior, and this will replace all shading formatting
in the worksheet.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim ws As Worksheet

Set ws = Worksheets("CA RESULTS")
ws.Cells.Interior.Color = vbWhite

ActiveCell.Interior.Color = 127

Set ws = Nothing

End Sub

--
Kevin Backmann


"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!