My tracking workbook has 2 worksheets. The first is a list of delivery note
numbers. The 2nd is the tracking in its entirety. How can I make the
delivery note number on the first worksheet change colour or something
similar when it has been allocated on the main tracking worksheet?