How do I apply color to a lot of columns at once with the table tool?

[Anonymous1]

Here is an example dataset:

restaurant	restaurant_address	restaurant_phone_number	item	item_price	item_score
Ray's Chicken	930 Thompson Drive, Mechanicsburg, PA 17050	(549) 215-2737	Chicken Sandwich	$6	4
Ray's Chicken	930 Thompson Drive, Mechanicsburg, PA 17050	(549) 215-2737	Chicken Tenders	$5	8
Ray's Chicken	930 Thompson Drive, Mechanicsburg, PA 17050	(549) 215-2737	Chicken Pot Pie	$7	5
McDonald	575 S. Coffee St., Green Bay, WI 54302	(385) 700-8314	Big Mac	$5	3
McDonald	575 S. Coffee St., Green Bay, WI 54302	(385) 700-8314	Chicken Nuggets	$3	5
Greg's Ice Cream	7595 Fordham Street, Prattville, AL 36067	(469) 674-0693	Vanilla	$4	7
Greg's Ice Cream	7596 Fordham Street, Prattville, AL 36067	(469) 674-0694	Chocolate	$4	6
Greg's Ice Cream	7597 Fordham Street, Prattville, AL 36067	(469) 674-0695	Strawberry	$4	5

Here is my goal, it will be a .xlsx spreadsheet. Here is a mock-up made in Excel:

Goal:

1) Each field will have just enough space to make everything fit width-wise, both header and data for a column.

2) Border will be visible.

3) Certain columns will be of a certain color.

I know how to do it column by column but that takes a LONG time when my real data has like 70 fields... is there an easier way to apply color to a lot of fields at once in either of these two scenarios?

Scenario 1) The fields will have a keyword in it to identify which category it belongs in (ex: restaurant, item)

Scenario 2) The fields does NOT have a keyword to identify the category, no pattern.

I was hoping for a multi-select by holding down shift and clicking the columns in the table tool but no go...

Thank you for any advice or help!

[binuacs]

@Anonymous1 This can be achieved by using the Table tool. You can find more information in the below post about the Table tool

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Table/ta-p/49555

[Qiu · Accepted solution]

@Anonymous1 
I believe you want to be dynamic, which I can not really achieve but I do want to give a workaround.
Row and Column rules can be written to evaluate values in the data but not the field names.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Table-column-heading-rule-based-highli...

[binuacs]

@Qiu brilliant suggestion!!! 

@Anonymous1 Another option is to select the Dynamic or Unknown field and edit columns and make the formatting. Once that is done if you add any new columns in the input file the formatting will be applied by default

[Anonymous1]

@Qiu @binuacs Thank you both for your inputs, I have tried the suggestions here and Qiu got me closer to what I needed. I appreciate both your help very much!

[Qiu]

@Anonymous1 
Thank you for the feedback. Sorry for not completely figuring it out. 😁