Hi All,
I have an issue with adding a new row to an existing table, when i do this the same column 'G' has its fill colour changed from none to green, this happens if i drag to increase the table size or type on the next blank row and it adjusts the table for me.

I have in the past used VBA to change cell fill colours but they don't match the ones being filled in the table.
I can add new tables to the sheet and they don't have this happen.

Any ideas appreciated.

regards


Trevor