how to move cells down and keep conditional formatting

[Chelsea19]

hi,

im trying to keep conditional formatting for the new data.
i currently have
Range("A13:D13").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove

this moves the data in A13-D13 down so that new data can go into A13-D13 however this new data does not have the same conditional formatting is there anyway i can keep the conditional formatting in the cells A13-D13?

[PCI]

You could
Copy Range("A13:D13") to Range("A14:D14")
Delete Range("A13:D13") contents
Or
Insert cells as you are doing
Copy Range("A14:D14") to Range("A13:D13")
Delete Range("A13:D13") contents

[Chelsea19]

You could
Copy Range("A13:D13") to Range("A14:D14")
Delete Range("A13:D13") contents
Or
Insert cells as you are doing
Copy Range("A14:D14") to Range("A13:D13")
Delete Range("A13:D13") contents

I need to be able to move down the data every time I enter a new input and therefore can’t copy into new cells

[PCI]

I need to be able to move down the data every time I enter a new input

Where do enter data in Range("A13:D13") ??
In others words where is your code

Please Login or Register  to view this content.

Attach a short Excel sample and it will be clear

[PCI]

See next code and comment

Please Login or Register  to view this content.