Forum Discussion
Solved
Conditional Formatting if date is past And Cell is Blank
Hello, Am trying to find a formula that works if a date is past today's date and the another cell is blank to highlight the date cell red, until the blank cell is filled.
@bhushan, thank you very much for this. Greatly appreciated 🙂
TemiT20 Hello! This formula was also helpful for me. I am hoping you have time to help me with a modification? Is there another variable I can add to restrict it to read only the row that it is in? I have values in a table, but for what is blank beneath it, it still highlights all blank cells. I tried the formula below, but that is just highlighting my header row for reasons I can't explain.
=IF(AND($H2<TODAY(),$J2="",NOT(ISBLANK($A2))),1,0)