Hi Millz, it seems to work but if the cell in sheet 1 is removed, the formatting in sheet 2 remains? Is there a way that if the number in sheet 1 is removed it will revert back to the original formatting i.e. un-highlighted? cheers