maximillianrg
Board Regular
- Joined
- Aug 7, 2014
- Messages
- 74
- Office Version
- 2016
- Platform
- Windows
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)
Thoughts?
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
Thoughts?