Done it!

I tried Peo's method - I couldn't figure it out at first, but I went through
the formula to see what was happening, made a few adjustments and now it
works a treat!

Thanks to both of you for your help.

Darrell.
PS: don't suppose either of you know anything about conditional formatting?
I may have to add another post if I can't work it out!