0

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

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

1 Answer 1

Reset to default
0

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

Improve this answer
1
  • @Max are you comfortable with conditional formatting with custom formula's? Commented Jan 15, 2021 at 17:53

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.