Hallo Jade,

Am Fri, 15 Jun 2012 12:12:46 +0000 schrieb Jade Summers:

Thank you so much for your quick reply! Unfortunatly that isn't working
for me. It's just turns all cells that were red (both dates and blank)
no colour. However this does seem to fix the issue of putting
0/Jan/1900.

for me it works fine. Take a look at the range F166:F1100:
https://skydrive.live.com/#!/view.as...182 2A3%21206


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2