conditional formattinggoogle sheets
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.
With the range set to: B3:O1000
Try:
=AND(ISBLANK(B3),INT($A3)=INT(today()))
or even shorter:
=AND(ISBLANK(B3),$A3=today())
You can use a range as a parameter for the ISFORMULA() function.
e.g. If you want to highlight all cells containing formulas in the range A1:J10, then you can use the formula =ISFORMULA(A1:J10) and apply it to the range A1:J10.
Note that this works with normal ranges (e.g. B2:F30), but not with infinite ranges (e.g. B:F).
Best Answer
Please try the following formula for the range
D137:D152