Populate Excel cells based on multiple IF conditions in VBA

I have a terrible headache on the following conditions:

The difference between a date given in cell (i, 9) and NOW() should undergo the IF procedures set presented below in the macro - in another cell (i, 13) it should display certain text with coloring (warning).
However, if (i, 9) is empty, then cell (i, 10) should follow the same set of IFs.
If there is nothing in both cells, the warning cell (i, 13) should remain empty.

I was able to create only the first condition, which is working fine, however, I have no idea how to approach the second one. Does anyone have an idea how to create a loop where this would work? Unless I did not describe the issue clearly enough. Thank you in advance!

Please Login or Register  to view this content.

Hi

Try this.

Please Login or Register  to view this content.

If that doesn't really do what you are chasing, then add an example file. I'm not sure about the last test you have that you want to really clear out column 13 if column 9 is blank...

rylo