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:for green andFormula:
=ISBLANK(E2)for red; both applied toFormula:
=NOT(ISBLANK(E2))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.Formula:
=$A$2:$E$99999
Bookmarks