Conditional Formatting for multiple range

[Laosi]

I wonder can we make conditional formatting in excel to hightlight certain values in multiple ranges in a couple of certain columns?

A	B	C	D	E	F	G
1	value	Percentages of Total	value	Percentages of Total	value	Percentages of Total
	109	61,24%	122	61,93%	145	61,18%
	50	28,09%	54	27,41%	67	28,27%
	19	10,67%	21	10,66%	25	10,55%
	178	100,00%	197	100,00%	237	100,00%
2	Values	Percentage of Total	Values	Percentage of Total	Values	Percentage of Total
	1	0,77%	1	0,69%	2	1,16%
	0	0,00%	0	0,00%	1	0,58%
	1	0,77%	1	0,69%	2	1,16%
	4	3,08%	4	2,78%	6	3,47%
	11	8,46%	14	9,72%	15	8,67%
	17	13,08%	18	12,50%	23	13,29%
	17	13,08%	21	14,58%	27	15,61%
	20	15,38%	22	15,28%	27	15,61%
	31	23,85%	32	22,22%	36	20,81%
	28	21,54%	31	21,53%	34	19,65%
	130	100,00%	144	100,00%	173	100,00%
3	Values	Percentage of Total	Values	Percentage of Total	Values	Percentage of Total
	76	45,24%	85	46,45%	102	46,58%
	4	2,38%	4	2,19%	4	1,83%
	29	17,26%	32	17,49%	37	16,89%
	7	4,17%	7	3,83%	8	3,65%
	20	11,90%	21	11,48%	26	11,87%
	6	3,57%	6	3,28%	6	2,74%
	12	7,14%	14	7,65%	17	7,76%
	3	1,79%	3	1,64%	3	1,37%
	7	4,17%	7	3,83%	8	3,65%
	1	0,60%	1	0,55%	5	2,28%
	3	1,79%	3	1,64%	3	1,37%
	0	0,00%	0	0,00%	0	0,00%
	0	0,00%	0	0,00%	0	0,00%
	168	100,00%	183	100,00%	219	100,00%

so for example all 3 tables in a worksheet, all tables had different row lengths and i want to hightlight automatically 3 largest percentages values in range between "Percentage of Total" and "100,00%" which is the sum of percentages in each tables.

so for Table 1 all of cells between "Percentage of Total" and "100,00%" will be hightlight,

for table 2 highlight values are 23,85%;21,54%;15,38%(1st column), 22,22%;21,53%;15,28%(2nd column), 20,81%;19,65%;15,61%(3rd column)

and for table 3 it would be 45,24%;17,26%;11,90%(1st column), 46,45%;17,49%;11,48%(2nd column) and 46,58%;16,89%;11,87%(3rd column).

Is there a way to do that?

[v-aatheeque]

Hi @Laosi ,

Thank you for reaching out to Microsoft Fabric Community.

It seems that this issue is specific to Excel. Since this is the Fabric Community Forum, I suggest reaching out to the Excel Community for more prompt and relevant assistance.

Welcome to the Excel Community | Microsoft Community Hub

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.