I have a query around the auto-population or conditionally formatted cells. Example below:

enter image description here

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?

Conditional formatting rule set-up example

  • How exactly you set up your conditional formatting? Please post screenshot of that too. Jan 15, 2021 at 12:25
  • I have added to the original posting
    – Max
    Jan 15, 2021 at 13:00

1 Answer 1


For a quick and dirty solution: Make a new conditional formatting rule with ="" in the EQUAL TO box.

enter image description here

Make sure that this rule is at the top of all the rules, like this

enter image description here

Not like this:

enter image description here

  • @Max are you comfortable with conditional formatting with custom formula's?
    – Dave
    Jan 15, 2021 at 17:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.