Conditional Formatting with results from formula

Question

In cell C1 I have a simple formula showing a net change from two other cells. =B1-A1

I would like to use the icon set in conditional formatting to show graphically the change, along with the result.

How do I define the conditional formatting to show only positive or negative results?

I would like the green arrow for positive changes and the red arrow for negative. I can get part of this to work, but if I change the data in A1 or B1, the conditional formatting doesn't change the result.

How did you define the conditional format (the one that "doesn't work") — Floris
– Floris, Commented Oct 8, 2013 at 19:08

Community · Accepted Answer · 2020-06-20 09:12:55Z

3

I suggest two rules, one merely to take precedence over the icon set when C1 is zero (as adjusted for the accuracy required):

SO19256108 example

In the image the value in B1 is 99.99999

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Oct 8, 2013 at 19:27

pnuts

59.8k11 gold badges93 silver badges141 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Doug Glancy Over a year ago

+1 Here's a Bacon Bits post that discusses this in depth.

Collectives™ on Stack Overflow

Conditional Formatting with results from formula

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related