Change Color of active cell

[Amar Verma]

How do i change color of a cell when selected and it goes back to default color when another cell is selected or when i click a command button in my sheet.

 

[VoG]

Select the cells of interest, apply this Conditional Format formula and set a fill colour

=AND(ROW()=CELL("row"),COLUMN()=CELL("col"))

Then right click the sheet tab, select View Code and paste in

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.ScreenUpdating = True
End Sub

 

[Amar Verma]

Hello again!
you are my help again. Let me explain a little more. I have a workbook with almost 130 worksheets all linked together. All the worksheets are password protected. The only cells that are unlocked where i want my coworkers to do data entry. What i want is everytime they select a cell it changes to a different color so that just in case they got busy doing something else and when they return they know what cell they were on. I am new to excel and a self learner. The cells they can select are excel's default color. Is it possible to cells change the color when they select them and go back to their default color when other cell is selected or when they click the command .
Thanks in advance.
Amar