Automatingcells within a column within Excel
 

I have created a list which has conditional formatting attached to it. This
populates a column in a spreadsheet which has the capacity to grow very
quickly. Is there anyway to automate the cells in this column being
populated with this data when a new row is inserted into the sheet.

All suggestions gratefully received.

thank you.