I have right clicked a selection on excel and created a list. On this
list I have also added conditional formatting to color the cells in
each column a different color. When I add new things to the bottom of
the list the Conditional formatting does not always follow along.
Most of the formatting seems to go away as well. Any help would be
greatly appreciated.

Thanks,
Jay