Hi ChemistB

Many many thanks, this is nearly there, the only issue is it appears to colour the cell that is two to the right, instead of colouring the cell that the data was entered into. I cannot figure out why this is happenning, any thoughts?

Gmmunro