#1
|
|||
|
|||
New table line has some cells fill colour change
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 |
#2
|
||||
|
||||
Please post a sample sheet ( no pics please) Thx
|
#3
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Text box fill colour changes when pasted to new file | ParishPete | Publisher | 0 | 06-21-2019 12:47 AM |
How to insert a diagonal line across multiple cells in a Table? | Joey Cheung | Word Tables | 1 | 10-10-2014 07:15 PM |
How-TO format cells (FILL) by comparing cells | zanat0s | Excel | 1 | 07-03-2012 04:27 AM |
How to fill a font colour to a particular data appear so many times in a column? | PRADEEPB270 | Excel | 0 | 03-22-2012 02:04 AM |
Accessibility Display & Colour Fill in Shapes | thorn | Office | 0 | 08-11-2011 07:58 AM |