Conditional formatting to determine when long service award due

[Prish]

Hi, I want to calculate when a long service award is due 6 months in advance based of today's date for each category, hopefully by highlighting the cell with conditional formatting.

This is my data:

	A	B	C	D	E	F
1	Today:	22-Oct-18
2
3	NAME	START DATE	LENGTH OF SERVICE	15Yr Award Due	20Yr Award Due	25Yr Award Due
4	Person 1	01 Jul 2003	15 years, 3 months	01 Jul 2018	01 Jul 2023	01 Jul 2028
5	Person 2	01 Nov 2003	14 years, 11 months	01 Nov 2018	01 Nov 2023	01 Nov 2028
6	Person 3	01 Jan 1999	19 years, 9 months	01 Jan 2014	01 Jan 2019	01 Jan 2024
7	Person 4	01 Feb 1994	24 years, 8 months	01 Feb 2009	01 Feb 2014	01 Feb 2019

<tbody>
</tbody>

Sheet1 (2)​

Worksheet Formulas (First Row only) Cell Formula B1 =TODAY() C4 =IF(B4="","",DATEDIF(B4,$B$1,"y")&" years, "&MOD(DATEDIF(B4,$B$1,"m"),12)&" months") D4 =DATE(YEAR(B4)+15,MONTH(B4),DAY(B4)) E4 =DATE(YEAR(B4)+20,MONTH(B4),DAY(B4)) F4 =DATE(YEAR(B4)+25,MONTH(B4),DAY(B4)) <tbody> </tbody>

<tbody>
</tbody>

And this is the result I want to achieve:

	A	B	C	D	E	F
1	Today:	22-Oct-18
2
3	NAME	START DATE	LENGTH OF SERVICE	15Yr Award Due	20Yr Award Due	25Yr Award Due
4	Person 1	01 Jul 2003	15 years, 3 months	01 Jul 2018	01 Jul 2023	01 Jul 2028
5	Person 2	01 Nov 2003	14 years, 11 months	01 Nov 2018	01 Nov 2023	01 Nov 2028
6	Person 3	01 Jan 1999	19 years, 9 months	01 Jan 2014	01 Jan 2019	01 Jan 2024
7	Person 4	01 Feb 1994	24 years, 8 months	01 Feb 2009	01 Feb 2014	01 Feb 2019

<tbody>
</tbody>

Sheet1

​

 

[Fluff]

how about
=AND(E4<=EDATE(TODAY(),6),E4>TODAY())