How do i highlight the active cell in Excel?

[Zilla]

Is there a way to highlight the active cell in excel, so that when you click on a cell it shows up in yellow or some other color? I'm not referring to the option to use the paint bucket to fill the active cell. I want the highlight to disappear from the active cell the another cell after it is no longer the active cell.

Can this be done for all of excel at once or only a workbook?

 

[VoG]

On a per worksheet basis:

Select the range that this should apply to, apply the following Conditional Format formula

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

apply a format and OK your way out.

Right click the sheet tab, select View Code and paste in

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

 

[Zilla]

followed directions to the T. But no color its a bit jumpy when i click from cell to cell. Was I suppose to select a color?

Edit: I forgot to select color in the Conditional Formatting area once I did all is well.

Thanks for the quick response and help.

 

[VoG]

Was I suppose to select a color?

That's what I meant by "apply a format".