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

SyedGangsta

New Member
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

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

AndyCoder

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

Try each setting, should show you trends:

Replies
0
Views
122
Replies
7
Views
89
Replies
11
Views
154
Replies
7
Views
96
Replies
3
Views
212

1,136,434
Messages
5,675,843
Members
419,586
Latest member
RoteichA

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back