Increase/Decrease of value set

[EmielCusters]

Hello,

I'm dealing with the following problem.
Say I have a set af values:
A B
1 567
2 546
3 567
4 554
5 572
6 543

I can easily determine the average of the values in column B (=AVERAGE(B1:B6))
But I also want to know if the average is increasing or decreasing without making a chart and trendline.
Concrete: I want the cell with average (say B7) to turn green when the trendline has a positive growth and red when negative.
Is such a thing possible? And yes, how?

B.R.

Emiel

 

[abductee]

Ok I'm not really sure how your tracking the growth but if you are going to use the average formula in B7 then you can apply conditional formatting to say turn green if value > B6 or tuirn read if less than B6

Conditional Formatting to cell B7
Condition1
Cell Value is [greater than] =$B$6 [apply green format]
Condition 2
Cell Value is [less than] =$B$6 [apply red format]

however I'm not sure you've explained your self quite right I think you want to highlight each cell to see if the trend is growing or declining for example you want to turn
B2 red because 546 is below the 556.5 average
B3 Green beacuse 567 is above the 560 average
B4 Red
B5 Green
B6 Red

Sooo
again apply conditional formatting but this time to Cell B2:
Conditional Formatting
Condition1
Formula Is =B1<AVERAGE($B$1:$B2) [apply green format]
Condition 2
Formula Is =B1>AVERAGE($B$1:$B2) [apply red format]

copy this cell then paste special to other cells as format ONLY



o
\__/\o
(Oo}
(=-) .===o- ~Z~A~P~
/'''''''\/U'
l l \_/
\\__)
E''''|
| ||
| || The
(__\\ Abductee

 

[EmielCusters]

Hello Abductee,

thanks for the reply. I just found out how to do it. Actually it was pretty easy
B7 average
B8 -> =SLOPE(B1:B6;A1:A6)
And then conditional formatting on cell (green arrow up if positive, red arrow down if negative)
The point was that the value of the slope doesn't matter to me, only if it is positive or negative.

But again, thanks for taking the time to react.

BR, Emiel