Forum Discussion
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 today is before date in I3, and J3 is blank,then J3 remains the color in the cell as shown in J5 with I5 date of 22 July 23 (that color is based on other conditional formats). If a date is entered into J3, then the red highlight is to be removed as shown in J4 (J4 has entry of 18 June 23).
12 Replies
- thanks!
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.
NikolinoDE Thank you so much! That worked perfectly! I think I tried every other combination of this formula you could think of but this one. You rock!
- I am glad that I could help you.
I wish you continued success with Excel!
Mark and Vote the answer if it helps please, as it will be beneficial to more Community members reading here.
