Thanks that works great!
I unfortunately have another problem now:
I have data on sheet 1 that is transferred to a preset LIST in sheet 2 with
VBA.
I also added a sum formula outside of the list which needs to dynamically
move with the list expansion (Total does not work with the code).

If the rows with data on sheet1 are more than that contained in the preset
list on sheet 2, either the sum formula dissapears or cond. formatting with
your formula does not work, as the list is not expanding dynamically or the
shading stops at the old list settings.

Any ideas?