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.
You may apply the rule
=($F2<TODAY())*($E2>1)
to your entire range.
That is in the second sheet of the attached file.
Thankyou Very much sir ,
You give me a valuable information
it may reduce our error .