If I have column b that contains a 'X' and i have column d that contains a date. How can get the all X's in column B, thru row 300, to show red if no date exists in the corresponding date column

do i have to set the conditional formatting for each cell in column B?

thanks