I have resolved this by using Conditional formatting, see:-

http://www.excelforum.com/excel-gene...ml#post2134753

However I may have to return if I can't resolve my follow up question:-

http://www.excelforum.com/excel-gene...el-2000-a.html