I already have conditional formatting that checks columns E F G for blanks and changes the interior color if it detects that there is no data.
if cells in b c and d contain nothing then don't change interior color of cells E G, of that same row. However if b c, d does contain data then do change the interior color of the subsequent blank cells.