Colour formating of Table Columns

[Griffmaster]

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.

[JeteMc]

Perhaps the linked tutorial will help: https://exceljet.net/lessons/conditi...ula-in-a-table
If you need specific help please utilize the information in the banner at the top of page to upload a sample of the table that needs formatting.
Let us know if you have any questions.

[Griffmaster]

Thanks for that JeteMc.

Got it sorted, looks like I wasn’t applying the colour format to the whole of each column which caused it not to follow down.

There was a couple of lines behind the header row I hadn’t noticed.

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.