Conditional format for multiple columns - More help please

[Haokun]

Hi 

Below is the current table, I only need to do certain columns for conditional formatting. The column will be the header name with red colour. Also, there will be more columns, but any header contains "vs" i need to do the conditional formatting. For the data under red colour column, if the amount is more than 0, cell colour needs to be green, amount is less than 0, cell colour needs to be red. I don't know how to build it via "table" tool. Please advise me, thanks so much and appreciate your time!

C-1M Fund	C-1M BM	MS-1M Fund	MS-1M BM	ES-1M Fund	ES-1M BM	C vs M-1M Fund	C vs M-1M BM	C vs ES-1M Fund	C vs ES-1M BM	M vs ES-1M Fund	M vs ES-1M BM	C-3M Fund	C-3M BM	MS-3M Fund	MS-3M BM	ES-3M Fund	ES-3M BM	C vs M-3M Fund	C vs M-3M BM	C vs ES-3M Fund	C vs ES-3M BM	M vs ES-3M Fund	M vs ES-3M BM
-1	-1.11	0	0	-1	-1.11	0	0	0	0	0	0	3.25	2.81	0	0	3.25	2.81	0	0	0	0	0	0
-0.62	-0.84	1.43	0	-0.62	-0.84	-2.05	0	0	0	2.05	0	2.42	3.17	0.35	0	2.42	3.17	2.07	0	0	0	-2.07	0
-1.11	-0.62	2.23	2.23	-1.11	-0.62	-3.34	-2.85	0	0	3.34	2.85	9.8	11.59	4.03	4.03	9.8	11.59	5.77	7.56	0	0	-5.77	-7.56
-2.12	-1.53	-0.99	-2.63	0	0	-1.13	1.1	-2.12	-1.53	-0.99	-2.63	4.13	3.7	-0.46	-0.05	0	0	4.59	3.75	4.13	3.7	-0.46	-0.05
-2.12	-1.53	-1.98	-2.63	0	0	-0.13	1.1	-2.12	-1.53	-1.98	-2.63	4.14	3.7	-1.46	-0.05	0	0	5.6	3.75	4.14	3.7	-1.46	-0.05
-0.94	-1.89	0.17	2.44	-0.94	-1.89	-1.11	-4.33	0	0	1.11	4.33	5.78	7.1	0.98	3.44	5.78	7.1	4.8	3.66	0	0	-4.8	-3.66
-0.63	-0.4	1.92	0	0	0	-2.55	0	-0.63	-0.4	1.92	0	6.71	4.57	3.39	0	0	0	3.31	0	6.71	4.57	3.39	0
-0.63	-0.4	1.92	0	0	0	-2.55	0	-0.63	-0.4	1.92	0	6.71	4.57	3.39	0	0	0	3.31	0	6.71	4.57	3.39	0
-3.62	-3.45	-3.03	-2.66	0	0	-0.59	-0.78	-3.62	-3.45	-3.03	-2.66	1.14	6.46	-4.81	-0.17	0	0	5.95	6.63	1.14	6.46	-4.81	-0.17

[ehughes · Accepted solution]

Hi Haokun,

You'll need to create Column Rules in the Table Tool. As far as I know, you need to create the column rules for each individual column where you want the conditional formatting. You can then create multiple rules for the column (so for column>0, apply green text and for column<0 apply red text). I've attached some screenshots that show you how you might configure the Column Rules. To view the formatting, make sure to add a browse tool at the end.

[Haokun]

@ehughes 

would be any easier way? cause there will be over 50 columns to do conditional formatting in my case...

thanks!

[atcodedog05 · Accepted solution]

Hi @Haokun 

Apparently there is no other way. You need to specify rule for all columns.