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

Please post a sample sheet ( no pics please) Thx

I was going to but when i copied the sheet to a new workbook the problem went away, so to fix it i'll just export then import the sheet.

thanks anyway.