, Good afternoon.
Select cells at colunm D to apply the CF.
Menu Conditional Format
=AND(NOT(ISERROR(SEARCH("*DEMO*", $A2))), $D2<15)
Select colour format as desired
Please, tell us if it worked as you desire.
I hope it helps.
Belo Horizonte, Brasil