Forum Discussion
Solved
Highlight series of cells if 1st or last row contains text
Hello, I have a worksheet that contains a few rows for each employee. The ID # is in column A, and column E will contain a calculated numeric value. For each employee, I would like to highlight al...
richzip505 You may use the following formula-
=IF(SUM(FILTER($E$2:$E$32,$A$2:$A$32=A2))>0,TRUE,FALSE)Actually you don't need IF(). Just could try-
=SUM(FILTER($E$2:$E$32,$A$2:$A$32=A2))>0
richzip505 You may use the following formula-
=IF(SUM(FILTER($E$2:$E$32,$A$2:$A$32=A2))>0,TRUE,FALSE)
Actually you don't need IF(). Just could try-
=SUM(FILTER($E$2:$E$32,$A$2:$A$32=A2))>0
Harun24HR Thank you, that works perfectly!
