You can right click the sheet tabview codeleft window select
worksheetright window use _selectionchangewrite your code
Give more examples such as always 3 rows more than the selection and always
cof d:f, etc
and it could be pretty simple to code
--
Don Guillett
SalesAid Software

"hampster" wrote in message
oups.com...
I am trying to change the color in a range of cells that is triggered
by selecting a separate cell. Example-- select A1 and the range
d5:f10 changes to green. Select another cell - A2 and the previous
selection goes back to its original color and the range associated
with A2 is then changed to green. Etc.... This would be similar to
A1 being a button, but there will be data entered into A1. Any
advice???