I would like to highlight the value in column D
if any of the cells in the same rows from columns E:K
are not blank. I have tried this formula in custom formatting:
=NOT(ISBLANK($E137:K137))
This works for that one cell, but when I apply to range (D137:D152
) it highlights all of the cells in range D
, even though some of the rows are blank.