Hi 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!
See Debra Dalgleish's Conditional Formatting tutorial at:
http://www.contextures.com/xlCondFormat01.html
---
Regards,
Norman
"dazp1970" wrote in message
...
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!