Looking for the formula for conditional formatting...
I have dates in column I and "Yes" or "No" in each corresponding cell in Column J. I want the dates in column I to turn certain color if the date is past today and column J is "No".
So far, I have =IF($J$2$:$J$1001$="N" ... I want to include date is past today then turn orange (or any color) but stuck on the second part.
Any help here?
Bookmarks