I've had this problem with a couple of Data Lists now and can't find a way to
resolve it.

When I set up the list, although it copies down to a new row the formulae
and cell general formatting, I can't get it to copy the conditional
formatting. However many times I try, it's fine until I step out of the list,
but when I step back in, the conditional formatting is lost.

Is this possible?

When copying Conditional Formatting formulas be careful about the placement
of $ signs for relative and absolute references.

=$A$1 will always point to A1

=$A1 will always point to column A but row reference changes


Gord Dibben MS Excel MVP

On Fri, 24 Jul 2009 07:18:00 -0700, FMS
wrote:

I've had this problem with a couple of Data Lists now and can't find a way to
resolve it.

When I set up the list, although it copies down to a new row the formulae
and cell general formatting, I can't get it to copy the conditional
formatting. However many times I try, it's fine until I step out of the list,
but when I step back in, the conditional formatting is lost.

Is this possible?