Conditional Formatting - Upcoming Dates and Blanks

so we are onlyinterested in thejobs that have started or are in 2 weeks
=AND(C4-TODAY()>=0,C4-TODAY()<=14). When a job has started, it highlights the cell red using =C4<TODAY().

so we could use those rules

=OR ( AND($C4-TODAY()>=0,$C4-TODAY()<=14) , $C4<TODAY() )

and ADD
D4=""

so

=AND( OR( AND($C4-TODAY()>=0,$C4-TODAY()<=14) , $C4<TODAY() ) , D4 ="")

probably can simplify this down - BUT just using your logic so far

see attached