How to highlight 5 consecutive cells with a word of "Need attention"

[Lolipop]

Hi all,
I want to highlight cells when the row has 5 consecutive (or more) "Need attention". I only want to highlight cells with a word of "Need attention", and only if there are at least 5 consecutive word of "Need attention". The cell values are from a formula.

Thank you in advance.

 

[Peter_SSs]

Give this a try

23 07 23.xlsm
	D
1	Signal
2
3	Need attention
4
5
6	Need attention
7	Need attention
8	Need attention
9	Need attention
10	Need attention
11
12	Need attention
13	Need attention
14
15	Need attention
16	Need attention
17	Need attention
18	Need attention
19	Need attention
20	Need attention
21	Need attention
22
CF 5

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:D22	Expression	=AGGREGATE(15,6,ROW(D2:D$1000)/(D2:D$1000<>"Need attention"),1)-AGGREGATE(14,6,ROW(D$1:D2)/(D$1:D2<>"Need attention"),1)-1>=5	text	NO