how to format all the similar values in cells with thick border in teh table having large values..

@Chaturvedi, Santosh Not sure about the thick outside border, but if you can accept different colour bands when the value in C changes, use this CF formula:

=MOD(SUM(IF(FREQUENCY($C$29:$C29,$C$29:$C29),1)),2)

It will create a view like in the picture below.

yep - likely the cleanest way is to use Conditional Formatting so Excel automatically places a thick top border at the beginning of each new value group in column C and a thick bottom border at the end of each group. This will continue to work even when the table contains thousands of rows.

Assuming your data starts at row 29 and the table spans columns B:H, select the entire table range, for example B29:H5000. Go to Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format.

For the thick top border, use this formula:

=AND($C29<>"",$C29<>$C28)

Set the format to have a thick top border. This detects whenever the value in column C changes from the row above. In your example, it would put a thick top border on row 29, row 38, row 47, and so on.

Create a second Conditional Formatting rule for the thick bottom border using:

=AND($C29<>"",$C29<>$C30)

Set the format to have a thick bottom border. This detects whenever the value in column C changes on the following row. In your example, it would put a thick bottom border on row 37, row 46, row 55, and so on.

The result will visually separate the stacked groups like this: rows 29–37 will be one boxed group because C29:C37 all contain 64.65; rows 38–46 will be another group because C38:C46 contain 61.05; rows 47 onward will form the next group when the value changes. You do not need to manually add borders, and if you insert additional rows or change the values in column C, the group borders will update automatically.

Note that if you want the thick border to surround only column C rather than the entire table, select C29:C5000 instead of B29:H5000 when creating the rules. If you want each group visually separated across the entire table, use B29:H5000.

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin