Good day everyone,
I have an excel sheet to keep track of who has taken a course, when they
took it, which automatically calculates ten years from then for the
My issue is even the blank cells for people who did not take the course
(H2 Expiry date) get affected by my conditional formatting and turn
green which is only supposed to be for dates 6 months past today and
I want to make the blank cells in H to stay white, which my conditional
formatting is still effective for the other information.
Here are my formulas:
H2 to add 10 years to when they took the course
I know I am missing something obvious, and I thought I had already fixed
it but I cannot seem to figure it out.
Thank you for your help!