Hi.
Have a Table with some 15 columns.
Only cells in the middle 5 columns are for inputting values whereas the 5 columns either side have calculations which take place.
I would like to add a colour to the centre 5 columns to highlight that only these columns should have input values entered.
I have added a colour to these columns which look OK on the values already entered but when I move down to the next line although the formulas index down to the next line the colour formatting doesn't.
How can I carry the colour formatting down automatically when indexing down to the next line?
Thanks.
Bookmarks