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:
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.