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.
sir ,
I mean if the master instrument is has an expiry date ,
when it due we want to highlight .
I mean if the master instrument is has an expiry date ,
when it due we want to highlight .
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"?
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