Duplicate in a Range

Hello,
I have a unique problem I am not able to find out the solution. I have an excel file with the Range of numbers listed in the columns like this

1000-2000
500-600
100-120
1000-3000
6000-7000
8500-9632

I need to highlight each row which is not unique. Meaning, the above sample data should highlight 1st row because they are covered in the 4th row. So basically the lower range should be highlighted

Any help is appreciated.

Proton.

Two questions. Is all you data in one column or two.? Difficult to determine. I don't know what you mean by Covered in the 4th Row. Perhaps you need to explain your criteria/rationale in more detail so that we fully understand.

I still know what you mean by "covered." Please explain what this means.

Sorry, you have not explained the criteria. I am out. Good Luck.

With Conditional formatting

1. Select the cells you want to format.
2. Create a conditional formatting rule, and select the Formula option.
3. Enter this formula:

Please Login or Register  to view this content.

4. Set formatting options and save the rule.

Note: change in the formula "A2" and "$A$2" for the cell where the data begins, change in the formula "A7" and "$A$7" for the last cell with data.