Conditional Formatting

[Jamiek1]

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)

 

[Joe4]

That should work if the formula returns an empty string, but I am guessing that your formula does not.
Can you post the formula found in cell I2?

 

[awoohaw]

To add on to what @Joe4 wrote.
I think your date calculation may be backwards. As with each passing day the TODAY() function will make the difference lesser than 7.

So, maybe try this:

=AND(I2="",TODAY()-J2>=7)