tracking changes in percent

thestackmonkey

New Member
Joined
Oct 17, 2005
Messages
14
I need some help. The boss has asked me to create a spreadsheet that will track changes from month to month. I am close but my percent of change is not making any sense when there is a decrese form one month to the next. I am using formulas to make the cell color red for a decrease and green for an increase, however everything is coming up as green. Can anyone help? This is most likely simple for most, but I am a field tech, self teaching excel.
Thanks

Example
Value % of Change
Jan 300

Feb 100

March 200
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

dixon1983

Board Regular
Joined
Apr 23, 2005
Messages
175
Use conditional formatting.

Highlight the column from the second value to the last.

In conditional formatting use the formula is option and use : =A2>A3 then set the format to Red font.

add another conditon being =A2<A3 with Green font.

This should do it I think. Hth.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
50,645
Office Version
  1. 365
Platform
  1. Windows
thestackmonkey

Is this what you want?

1. Format column C as Percentage (Format|Cells...|Number|Percentage|OK)
2. Formula in C3 (copied down): =(B3-B2)/B2
3. Select C3:C7 (Adjust to suit)
4. Format|Conditional Formatting...|Condition 1|Cell value is|Greater than|0|Format...|Patterns|choose green|OK|Add>>|Condition 2|Cell value is|Less than|0|Format...|Patterns|choose red|OK|OK
Mr Excel.xls
ABCD
1Value% Change
2Jan300
3Feb100-66.67%
4Mar200100.00%
5Apr2000.00%
6May25025.00%
7Jun200-20.00%
8
Percentage Change
 

Forum statistics

Threads
1,141,626
Messages
5,707,489
Members
421,510
Latest member
haroonstr

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