Try this little event macro:

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

--
Gary''s Student - gsnu200724


"kdadman" wrote:

In Excel 2007 when I click and highlight a croup of cells, the background
color is "annoying". How can I change it so whenever I select a group of
cells they are highlighted in a color I would prefer.

I know I can change the background of cells, I just want to change the color
that they turn whenever any cells in the workbook are highlighted.