Merging two formulas for use in conditional formatting

[maximillianrg]

Thank you for your help in advance

I'm trying to figure out how apply conditional formatting to a date in cell J49 bases on two factors, the date in cell J49 and the contents of cell A49, here is the logic. In the below examples, bad means conditional formatting would be applied (the date would be changed to RED), and good means conditional formatting would not be applied (the date would be black or default)

• =IF(AND(A49=0,J49<>TODAY()),"bad","good") so if today is 2/6 and the date in cell J49 is not 2/6 AND cell A49 = 0 conditional formatting would be applied
• =IF(AND(A49="",TODAY()-J49>2,"bad","good") so if today is 2/6 and the date in cell J49 was 2/4 or earlier conditional formatting would be applied

So what I'm trying to do is combine and modify the two formulas into one so that conditional formatting would be applied to the date in cell J49 based on those formulas

Thoughts?

 

[DanteAmor]

Try:

=OR(AND(TODAY()-J49>=0,TODAY()-J49<=2,A49=""),AND(A49=0,TODAY()=J49))