I have the same problem. I have a series of rows and I insert just above the last one to copy the data validation and conditional formating to the inserted row. But in some columns, I have a series of formulas that do not copy to the newly inserted row. And as Khaldon, I did not set it up as a table, and already have all my formatting with headers, etc. Any ideas would be greatly appreciated. Thanks in advance.