Conditional Formatting

[bcowans]

Help please!
I have two different columns; D and E. Both columns have dates in their cells.
I need column D's cell to turn yellow when column D's date exceed 1 month or 3 months, or 6 months from column E's cell.
I know how to apply the color but I can't seem to find the code that will calculate that D exceeds the time from of E.
Example: Column D = 9/13/18, Column E = 8/7/18.
Column D was due to be seen no later than 9/7/18. Since it is past due, how do I get the format to reflect that?
Using the =NOW and =TODAY code doesn't seem to work.
Thank you for any help!

 

[JoeMo]

Say the dates are in D2 and E2, then if you are OK with col D cell filling yellow if the D date exceeds the E date by more than 30 days try this CF formula:

=D2 > E2+30

 

[bcowans]

Didn't work.

 

[JoeMo]

Didn't work.

That's not a helpful response. What exactly "didn't work"? How did you set up the conditional format?

 

[bcowans]

LOL sorry, I didn't think of putting the issue.
=D2-30>E2 I put that code and it worked.
Only issue now is, if it is the same date, different month, it will calculate it as late. Example: Column D = 9/7/18, Column E = 8/7/18.
Is there away to avoid that?

 

[JoeMo]

LOL sorry, I didn't think of putting the issue.
=D2-30>E2 I put that code and it worked.
Only issue now is, if it is the same date, different month, it will calculate it as late. Example: Column D = 9/7/18, Column E = 8/7/18.
Is there away to avoid that?

Increase the number of days overdue by 1.

=D2 > E2 + 31

 

[jtakw]

Hi,

May be use this for 1 month:

Book1
	D	E	F
2	9/13/2018	8/7/2018	TRUE
3	9/7/2018	8/7/2018	FALSE
Sheet334

Cell Formulas
Range	Formula
F2	=D2>EDATE(E2,1)

Change the 1 (number 1) within the formula to 3 for 3 months, 6 for 6 months.