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.
Thank You sir ,
That is not a issue ,
Our main Thing is "MI Number" According this MI Number our Certificate Number is issue
So that Duplication is a series issue .
At This time that issue is solved
Thank you for the feedback, so far so good