Thanks to both of you for the answer. Yes, I did need to change semicolons to commas. I experimented with Data Validation over the past few days but we found there were some times where we actually needed to enter an 'incorrect' number but we just needed to know about it so it didn't happen accidentally. So I've just made the cell become bright Pink when they don't match. Cheers Chris
|