Bob Phillips wrote:
You have to use VBA, you cannot set the colour on another sheet using a
function. Chip's function just returns the cell colorindex, it does not set
any others.

My code easily adapts to another sheet

iLastRow = Cells(Rows.Count).End(xlUp).Row
For i = 1 To iLastRow
Worksheets("Status").Cells(i,"C").Interior.Colorin dex =
Cells(i,"A").Interior.Colorindex
Next i

VBA?

[quoted text clipped - 40 lines]
as I say , I know it's me but as you may guess I'm not clued up on much of
VBA


Thanks for your patience Bob, but I get a 'subscript out of range' on the
worksheet row

--
Message posted via http://www.officekb.com