Cell color based on increasing or decreasing values in a column.

[SyedGangsta]

I wonder if some one has a tip on how to solve this conditional type formatting problem.

I want to color each cell based on if the value has increased or decreased from the value immediately below.

If the value is following a trend the color will get darker, so based on the values of column B.

May = light red
June = Medium red
Jul = Dark red

Aug = Light green
Sept = Medium green
Oct = Dark Green
Nov = Very Dark Green
Dec = Light Red
Jan = Light Green (value increased)
Feb = Light Red
Mar = Medium red

I could not see any of the conditional formatting that would do the same, although may be a value based on formula may work, but need some thing that can evaluate the trend of several rows, as in example.


[TABLE="width: 500"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]MAR[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]FEB[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]JAN[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]DEC[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]NOV[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]OCT[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]SEP[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]AUG[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]JUL[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]JUN[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]MAY[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]MAY[/TD]
[TD]11[/TD]
[/TR]
</tbody>[/TABLE]

Many thanks for any one that gives this a try... I will be grateful.

Reg

Attiq

 

[AndyCoder]

Select the Value Column
Go to HOME>Conditional Format>Data Bars>

Try each setting, should show you trends: