Hello! I can't figure out why my conditional formatting does not work as intended: I have 5 columns - A, B, C, D, E - and I simply want the rows, where cell E is empty, to be green and the rows, where cell E has a value - turn red. Pretty straight forward. In case individual cell format matters, I have entire columns A, B, and C with default "General" formatting and remaining D and E - as Date.

My formulas look as follows:
Formula: copy to clipboard
=ISBLANK(E2)
for green and
Formula: copy to clipboard
=NOT(ISBLANK(E2))
for red; both applied to
Formula: copy to clipboard
=$A$2:$E$99999
What happens is that only cells in the A column are turning red of the rows where the date value in column E is entered.