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

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.