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.

Month	Value
MAR	5
FEB	9
JAN	10
DEC	8
NOV	10
OCT	8
SEP	7
AUG	6
JUL	5
JUN	8
MAY	10
MAY	11

<tbody>
</tbody>

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: