Hi all,
I think I am overthinking this one and need some help please.
I am writing a conditional formatting formula so that cell B2 will highlight "purple" if cell i2 is blank and cell j2 7 days has passed since the date shown
I have input the below formula and it works if cell I2 is completely blank, however, I2 has a formula.
Is there a way to fix this so it does not read the formula and is just on the returned value?
=AND(I2="",J2-TODAY()>=7)
I think I am overthinking this one and need some help please.
I am writing a conditional formatting formula so that cell B2 will highlight "purple" if cell i2 is blank and cell j2 7 days has passed since the date shown
I have input the below formula and it works if cell I2 is completely blank, however, I2 has a formula.
Is there a way to fix this so it does not read the formula and is just on the returned value?
=AND(I2="",J2-TODAY()>=7)