I am trying to use conditional formatting to highlight a cell either green or red based off a previous value entered in the cell above.

I show an example as I am trying to format all my stats to show either green or red:

example here


1 Answer 1


Select ColumnH and apply a Custom formula is of:


with formatting of choice and Done.

Repeat for:


For both adjust the range to start at H2.

Since the conditions are exclusive (only ever one or the other) one rule might be sufficient (just 'standard fill' the entire range with the 'other' colour) but then "no change" would be highlighted, which it won't be with the two rules above.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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