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


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, privacy policy and cookie policy

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