Colour cell if Due Date is less than 8 days away

[rushdenx1]

The enclosed file shows a list of companies in three blocks all with a 'Date Due'. What I would like is a formula which will colour the white cells in Column E when the 'Date Due' is less that 8 days from today.

Book1
	A	B	C	D	E
1	Monthly DD
2	Company	For	Date	Per Month	Date Due
3	A	Gas & Electric	11th	£ 139.00	20/10/22
4	B	Council Tax	1st	£ 223.00	01/04/22
5	C	TV	1st	£ 67.50	04/05/22
6	D	Will	17th	£ 5.00	08/11/21
7	E	Music	24th	£ 9.99	12/11/21
8	F	Phone & BB	26th	£ 88.00	26/04/23
9	Yearly Bills			£ 532.49
10	Company	For	Per Year	Per Month	Date Due
11	G	Water	£ 488	£ 40.67	01/02/22
12	H	House & Cont	£ 320	£ 26.67	15/02/22
13	I	Car Insurance	£ 358	£ 29.83	22/08/22
14	J	TV Licence	£ 159	£ 13.25	01/11/21
15	K	Car Tax	£ 490	£ 40.83	01/08/22
16	L	Car Service	£ 1,000	£ 83.33	11/11/21
17	M	Internet	£ 12	£ 1.00	10/12/21
18	N	Doorbell	£ 25	£ 2.08	25/09/22
19	P	Cycling App	£ 105	£ 8.75	27/10/22
20	Purchases			£ 246.42
21	Company	For	Date	To Pay	Date Due
22	Q	Shutters	24/11/21	£ 350.00	24/11/21
23	R	Windows	16/11/21	£ 2,616.00	16/11/21
24	S	Cape Verde	07/02/22	£ 1,557.96	10/11/21
25	T	Kefalonia	07/07/22	£ 200.00	15/12/21
26	U	Kefalonia	07/07/22	£ 1,339.88	14/04/22
Sheet1

Cell Formulas
Range	Formula
D9	D9	=SUM(D3:D8)
D11:D19	D11	=SUM(C11)/12
D20	D20	=SUM(D11:D19)

 

[Fluff]

You can use conditional formatting for that & use this formula.

=AND(E3<>"",E3<TODAY()+8)

 

[rushdenx1]

You can use conditional formatting for that & use this formula.

=AND(E3<>"",E3<TODAY()+8)

Many Thanks. I am a bit of a newbie to Excel so how do I get the formula into all the white cells without having to manually input the conditional formatting formula into each cell.

 

[Fluff]

Select E3 down to the last row of data, then in conditional formatting, new rule, use a formula & enter the formula I posted.