Forum Discussion
Solved
Apply Conditional formatting for avoid Duplication
Here I am attached my worksheet We want to avoid duplication And also we have to copy and paste the row
Hi,
You have a lot of exactly the same rules but applied only to some rows, not all of them
Usually one colour - one rule is enough. If you apply one rule
=$B4=OFFSET($B4,-1,0)
to entire column
it shall work. Please see attached.
Hi,
Thank You for your replay,
Duplications of what?
I want to know the duplicate value of the MI Number
For example ,
I apply conditional formatting or data validation .
I copy the data of row number"2715" and paste the data on next row "2716"
at that time it does not working
Hi,
You have a lot of exactly the same rules but applied only to some rows, not all of them
Usually one colour - one rule is enough. If you apply one rule
=$B4=OFFSET($B4,-1,0)
to entire column
it shall work. Please see attached.