Quote Originally Posted by royUK
You can highlight dates using Conditional Formatting

http://www.excel-it.com/excel_condit...formatting.htm

You could use VBA to test for specified dates & print sheets or send emails. Attach an example of your data layout if you want sample code.
Thanks for the response Roy - looking good then!

Still need to produce the original document and have to do some research to get all aspects covered - but I'll do all that and get back to you!