![]() Open that and modify “Apply to range” to C2:I2 and “DONE.” screenshot # 2 Just enter the above formula and choose the color to fill the cells that contain the adjacent duplicate values.īelow that, find the option “Add another rule.” Then select “Custom formula is” under “Format rules.” Also, to add the above formula rule.įind “Apply to range,” and enter B2:I2, which is the range to highlight for consecutive or adjacent duplicated cells. It will open the sidebar panel to enter the range of cells to highlight. You must apply this twice, first for the range B2:I2 and then for the range C2:I2. ![]() We can use the following LEN and Logical AND based rule for the column-wise data in B2:I2. Highlight All the Occurrence of Consecutive Duplicate Cells Later we can see how to exclude the first occurrence. In the first example, we will use a conditional format custom formula rule to highlight all the occurrences of duplicates in consecutive cells. Highlight Adjacent Duplicates Row or Column-Wise
0 Comments
Leave a Reply. |