Dear Colin Many thanks both for reply and for amazing swiftness. Silly of me not to think of attaching a file. That's pretty much what I want but when I tried that form of IF statement in Office 2010 it didn't work. Now it may well be my lack of experience of 2010, or with IF statements, or just plain carelessness, so I'll have another try and let you know how it goes. Thanks again, Andrew