Forum Discussion
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,
Could you please clarify a bit, you'd like to highlite duplications by conditional formatting and after that the person will do corrective actions; or you'd like to prevent with data validation?
- duplications of what?
- what prevents you to copy/paste the rows?
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.
