Now also cross-posted at:
Unconditional formatting not colouring the cells and not copying across | MrExcel Message Board
For cross-posting etiquette, please read:
Excelguru Help Site - A message to forum cross posters
I note you've already been pinged elsewhere for cross-posting without providing links. Keep it up and you'll find no-one will help you and your accounts on the forums whose rules you're violating may even be terminated.