Forum Discussion
Re: Apply Conditional formatting for avoid Duplication
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"?
3 Replies
- yes sir ,
we do calibration due date is highlighted manually
we want it automaticallyYou 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 .
