Forum Discussion
Apply Conditional formatting for avoid Duplication
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.
Yes, the formula will be
=COUNTIF($B$4:$B$10000,$B4)-1
and in attached file.
Please note it calculates duplicates on entire range, e.g. you have lot of records with Site and Mail in that column, they all are considered as duplicated in this logic.
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
Thankyou Very much sir ,
You give me a valuable information
it may reduce our error .
You may apply the rule
=($F2<TODAY())*($E2>1)
to your entire range.
That is in the second sheet of the attached file.
- yes sir ,
we do calibration due date is highlighted manually
we want it automatically In terms of your Excel sheet: you have manually highlighted rows for which "Cal. Dated" is greater than "Due Date". Would you like them to be highlighted automatically with conditional formatting or what?
And what is expiry date, is that "Cal. Dated"?
- sir ,
I mean if the master instrument is has an expiry date ,
when it due we want to highlight . Do you mean repeat the same with conditional formatting?
Here I am attached one excel sheet
For finding the due date
Please kindly help
Thank you for the feedback, so far so good