Hi

I have spreadsheet with two worksheets, "Admin" and "Format".

On the "Admin" sheet I have two named ranges. In these ranges I enter values
for ColorIndex and PATTERN which I want use to format a range A6:A10 on the
"Format" sheet.
Assume that my ranges are named as follows;
LineColor contains the value 35
LinePattern contains the value -4125

Can anyone help me cobble together a script that will apply this formating
to the cells A6:A10 in the sheet "Format"

Many Thanks - Grant