Hi all, this one has been getting on my nerves for a while now! Hopefully someone can help. I have some basic formula to work out the date 6 months after and nine months after column I.
I also have some conditional formatting to turn columns J & L red if the date exceeds TODAY() which also works fine.
What i am trying to do is either disable the conditional formatting in column J if the review has been completed and the same in L or create a new conditional formatting rule that turns the columns back to zero formatting if there is a review or an exit meeting entered.
Its the multiple formatting of a single cell based on the value of another cell that i'm struggling with or am i over complicating this?
Any advice would be much appreciated!
<tbody>
</tbody>
I also have some conditional formatting to turn columns J & L red if the date exceeds TODAY() which also works fine.
What i am trying to do is either disable the conditional formatting in column J if the review has been completed and the same in L or create a new conditional formatting rule that turns the columns back to zero formatting if there is a review or an exit meeting entered.
Its the multiple formatting of a single cell based on the value of another cell that i'm struggling with or am i over complicating this?
Any advice would be much appreciated!
I | J | K | L | M | N |
Date started | Review Date (6 months) | Review completed date | Exit meeting (9 Months) | Exit Meeting Date | |
01/01/2019 | =EDATE(I1,6) | 01/10/2019 | =EDATE(I1,9) | 07/08/2019 | |
<tbody>
</tbody>