Im trying to find a way to change the area that conditional formatting applies to automatically. I have a sheet that has data on it and I often add data to it from time to time and would like the conditional formatting to change with it automatically instead of me having to change the "applies to" range manually if possible.

for example if I have conditional formatting that applies to D2:AE200 and I add more data at row 201 can it see that was added and change the range.

I would just make the range larger than I need but i also use sort often and if the range is larger it sorts the empty rows as well.