I have a query around the auto-population or conditionally formatted cells. Example below:
As it stands, the amount column J has the formula =IF(ISBLANK(H9)+ISBLANK(I9)=2,"",H9-I9)
.
The entire column has conditional formatting: if the value in the cell is greater than 0 to format with green fill and dark green text. If the value is less than 0 to format with light red fill with dark red text.
For some reason, as in the image, when no data is entered into any cell, other than the above formula for its representative line it auto-fills to green.
How do I adjust the formatting so that there is no fill until the value of the cell is either greater than or less than 0?