Hi Fedde,

Does this happen in all the cells or only ones that you have copied the
formatting to?

If it is in the cells that you have copied it to, make sure that the
condition is not referring back to the original cell - you may have got
an absolute reference (with $ signs in it). If this is the case get rid
of the $ signs in the original and then copy down again.

otherwise it should work.

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=522530