Hello everyone,
I have got problem with conditional formatting.
In Column A and B a have got some values.
I'm looking for some way to hightlight duplicates values per columns. Of course I can create manually rules per column but finally file will be have over 1000 columns.
I need range where excel will be highlight duplicates.
For example:
<tbody>
</tbody>
Below screen:
https://imgur.com/4Vq9kKT
Thanks in advance.
I have got problem with conditional formatting.
In Column A and B a have got some values.
I'm looking for some way to hightlight duplicates values per columns. Of course I can create manually rules per column but finally file will be have over 1000 columns.
I need range where excel will be highlight duplicates.
For example:
Column A | Column B |
grapes | grapes |
mango | coconut |
melon | pear |
pineapple | peach |
pear | |
grapes |
<tbody>
</tbody>
Below screen:
https://imgur.com/4Vq9kKT
Thanks in advance.