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?
Use this as the CF formula:
=(AND(I2< TODAY(),J2="No"))
aplly to whichever column(s) you wish.
Last edited by Glenn Kennedy; 05-01-2017 at 10:55 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
tryFormula:
Please Login or Register to view this content.
in the conditional format box
Awesome, thanks so much Glenn!
You're very welcome...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks