Forum Discussion
Solved
Conditional format blank cell based on how many days past date in another cell
I need to highlight a cell if it remains blank 1 day past date in another cell. For example: I3 has date of 15 May 23. J3 is blank. If today is past date in I3, and J3 is blank, then J3 turns red. If...
NikolinoDE Can you help me as well? I need almost the same formula, except I need the blank cell to highlight if it has not been filled in within 3 days of the date in the previous cell (or rather, if today is 3 days or more past the date in the previous cell). I can't figure out how to add in the 3 days parameter. I'd also like the whole row to highlight rather than just the singular cell.
If I understand correctly... which is not always the case :)), this formula might help you.
=AND($I3<TODAY()-3, ISBLANK(J3))
If not, please add more information, such as a step-by-step (cell by cell) description of your project, Excel version, operating system, storage medium, etc. Preferably with a file (without sensitive data) or photos.
=AND($I3<TODAY()-3, ISBLANK(J3))
If not, please add more information, such as a step-by-step (cell by cell) description of your project, Excel version, operating system, storage medium, etc. Preferably with a file (without sensitive data) or photos.