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

Report •


#1
October 14, 2010 at 11:26:03
conditional formatting showing red increase, yellow same, and blue decrease

Sorry, 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-A14

Is 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.

MIKE

http://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


Ask Question