Difference between 2 columns, into 3rd cell

October 14, 2010 at 10:32:03
Specs: Windows XP
 Hello, I have been scanning the web trying to find a formula that can calculate the difference between 2 columns placing that number in a row below with conditional formatting showing red increase, yellow same, and blue decrease. Below is the actual numbers: dates followed by data below, and then the sum, with the difference between the rows (manually completed) If you would be so kind to assist, I'd be much appreciative - thank you for your time.10/10/10 10/11/10 10/12/10 10/13/10 10/14/10 10/15/10 366 375 375 377 378 257 257 257 253 253 55 55 55 56 56 32 32 32 30 30 5 5 5 5 5 28 28 28 28 28 4 4 4 4 4 336 338 337 338 337 198 198 198 194 191 400 400 400 391 391 14 13 13 13 13 1695 1705 1704 1689 1686 10 -1 -15 -3

See More: Difference between 2 columns, into 3rd cell

#1
October 14, 2010 at 11:26:03
 conditional formatting showing red increase, yellow same, and blue decreaseSorry, I can't figure out what your trying to do.You want to show red as an increase, from what?You want to show yellow as same, as what?You want to show blue as a decrease from what?What is the baseline that your working from?The formula for arriving at the totals is =SUM(A3:A13)The formula for arriving at the differences between columns is,starting at column B cell 15: =B14-A14Is 10 Red because it's greater than zero?Is -1 Yellow because it's the same as your baseline?is -15 Blue because it's a decrease from zero?You'll have give a bit more explanation.MIKEhttp://www.skeptic.com/

Report •

#2
October 14, 2010 at 13:14:18
 To line up your data in your post, please use the pre tags found above the Reply box.1 - Click the pre icon found above the Reply box.2 - Enter your data between the tags.3 - Click Preview Follow Up to see if you like the way it looks. 4 - If you need to fix the layout, fix it in the Message box below the Preview box.5 - Click the "Check To Show Confirmation Page Again" box.6 - Click either Confirm button to Preview the post again.Repeat steps 4 - 6 as often as necessary until you like the way the post looks and then click Confirm.

Report •

Related Solutions