Bob Phillips wrote:
That is probably because your worksheet is not named Status.

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
[quoted text clipped - 16 lines]
Thanks for your patience Bob, but I get a 'subscript out of range' on the
worksheet row




Oops,

Thanks a load

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