Change rangre color with scroll bar
 

I would like to change the color of a named range with scroll bar. As the
number in scroll bar cell link changes the color of the named range should
change accordingly. How ? What looks the code like ?

Change rangre color with scroll bar
 

http://pmexcelent.dk/ColorRange.xls


"PEES" skrev:

I would like to change the color of a named range with scroll bar. As the
number in scroll bar cell link changes the color of the named range should
change accordingly. How ? What looks the code like ?

Change rangre color with scroll bar
 

Thank You !


"excelent" wrote:

http://pmexcelent.dk/ColorRange.xls


"PEES" skrev:

I would like to change the color of a named range with scroll bar. As the
number in scroll bar cell link changes the color of the named range should
change accordingly. How ? What looks the code like ?