May 26 2021 05:48 AM
Hello everyone!!
I have a spreadsheet where I am tracking requests. I want Excel to highlight the row if the item due date (column B) is NEXT month or has PASSED (for when we receive late requests), but I only want it to highlight if the 'Date Completed' (column I) is not filled in. Once it is filled in, I want the highlight to go away.
I have tried multiple variations using both the AND, IF & ISBLANK function and cannot figure it out. Please help! :)
May 26 2021 05:57 AM
May 26 2021 12:21 PM
Thank you for your suggestion! That did not work though. It highlighted all of the items in column B that had passed, regardless if column I was filled in or not. @mtarler
May 26 2021 12:37 PM