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

SyedGangsta

New Member
Joined
Sep 21, 2013
Messages
24
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.


MonthValue
MAR5
FEB9
JAN10
DEC8
NOV10
OCT8
SEP7
AUG6
JUL5
JUN8
MAY10
MAY11

<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
Joined
Oct 9, 2017
Messages
5
Select the Value Column
Go to HOME>Conditional Format>Data Bars>

Try each setting, should show you trends:

 

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top