Chris,

Right click on the Tab of your worksheet and Paste this simple Worksheet
event:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

Cells.Interior.ColorIndex = xlNone
ActiveCell.Interior.ColorIndex = 6

End Sub


"blind chris" wrote:

scenario: i have to write down vendor id numbers on paper requests
numbers are 10 digits long and very similar to each other
the numbers are in one column, next column has the vendor names that the
number corresponds to.

since all the numbers are so similar. sometimes i write down the wrong
numbers when im in a hurry or if i dont put my finger directly on the monitor
(to reference wich number im copying down)

question: when i click on a cell. is there a way to make that cell stand out
in any way TEMPORARILY. (highlighted, change color, border etc) ... but just
until i click the next cell i need to write down. so the change cant be
permanent (so no formatting)