I am working on Excel 2021 that table can add new row automatically, But after make the sheet protect cannot add new row in the table! any solution please

I’m working with Microsoft Excel and looking for a way to dynamically apply color to a range of cells based on a range input provided in a specific cell (A1). The goal is to have the specified range (e.g., A12:DE45) filled with a certain color when entered into cell A1.