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