Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
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.
...highlight the value in Column D if any of the cells in the same rows from Column E:K are not blank
Please try the following formula for the range D137:D152
=NOT(COUNTIF(E137:K137,"<>")=0)
