How to make rows sort automatically even when a new row is added.

Is there a way to have the rows that are added with a more recent date to sort to the top of the child rows automatically? I found a way to sort to make this happen. But it does not do it when new rows are added. I always have to re-sort when rows are added. Is there a way to make this happen automatically?

And with that, is there a way to highlight the rows that were added within the last week to a different color just for that week so that there is a clear identifier that they are new rows?

Best Answer