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.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]