Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default Changing a cell color to reflect positive or negative total

How do I add a formula to make a cell color (red for negative, green for
positive) reflect a positive or negative total when adding/subtracting 2
different cells.

i.e. cell A43-A49, total sits in cell E49. If total is negative, then cell
E49 turns red; if positive, cell A49 turns green.

-A43 is a total of 40 previous cells added while A49 is the total of 4
previous cells added.

Thanks.

Alex


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,593
Default Changing a cell color to reflect positive or negative total

Use conditional formatting.

See http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Alex Vega" wrote in message
...
How do I add a formula to make a cell color (red for negative, green for
positive) reflect a positive or negative total when adding/subtracting 2
different cells.

i.e. cell A43-A49, total sits in cell E49. If total is negative, then cell
E49 turns red; if positive, cell A49 turns green.

-A43 is a total of 40 previous cells added while A49 is the total of 4
previous cells added.

Thanks.

Alex




  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,290
Default Changing a cell color to reflect positive or negative total


Or use a custom number format...

[Green]$#,##0_);[Red]($#,##0)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Alex Vega"
wrote in message
How do I add a formula to make a cell color (red for negative, green for
positive) reflect a positive or negative total when adding/subtracting 2
different cells.
i.e. cell A43-A49, total sits in cell E49. If total is negative, then cell
E49 turns red; if positive, cell A49 turns green.
-A43 is a total of 40 previous cells added while A49 is the total of 4
previous cells added.
Thanks.
Alex


  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default Changing a cell color to reflect positive or negative total

Thank you for responding.

Alex

"Jim Cone" wrote:


Or use a custom number format...

[Green]$#,##0_);[Red]($#,##0)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Alex Vega"
wrote in message
How do I add a formula to make a cell color (red for negative, green for
positive) reflect a positive or negative total when adding/subtracting 2
different cells.
i.e. cell A43-A49, total sits in cell E49. If total is negative, then cell
E49 turns red; if positive, cell A49 turns green.
-A43 is a total of 40 previous cells added while A49 is the total of 4
previous cells added.
Thanks.
Alex



  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 31
Default Changing a cell color to reflect positive or negative total

Just a general point - colouring cell backgrounds can make the content
unreadable, expecially if printed in monochrome (ie greyscale).
Changing the colour for the text can be more useful, using a custom format
as suggested perhaps. However, this does not lend itself to skim reading for
things (eg to quickly spot the negatives), nor is it any use for people with
some forms of colour blindness or again for monochrome printing. A couple of
options to help with this:
- use a conditional format to make one of the kinds of text bold as well (eg
the negative values)
- use a cond. format to add a cell border.
- include 'standout' text characters in the custom format to make cells
stand out eg [Green]* $#,##0_);[Red]"LOSS! "($#,##0)
--
Adam Vero
MCP, MOS Master, MLSS, CWNA
http://veroblog.wordpress.com
http://www.meteorit.co.uk


"Alex Vega" wrote:

How do I add a formula to make a cell color (red for negative, green for
positive) reflect a positive or negative total when adding/subtracting 2
different cells.

i.e. cell A43-A49, total sits in cell E49. If total is negative, then cell
E49 turns red; if positive, cell A49 turns green.

-A43 is a total of 40 previous cells added while A49 is the total of 4
previous cells added.

Thanks.

Alex


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Positive/Negative Running Total Scotty New Users to Excel 1 March 22nd 07 02:32 PM
Changing formuals from Positive to negative relliman Excel Discussion (Misc queries) 4 November 27th 05 04:34 AM
Changing Positive to Negative Matthew Hackett via OfficeKB.com Excel Worksheet Functions 2 June 28th 05 11:55 AM
simple query changing set of numbers from positive to negative sammy Excel Discussion (Misc queries) 2 May 1st 05 11:06 PM
How to vary color in an area chart between negative or positive d. Gulf Stream Charts and Charting in Excel 3 February 10th 05 06:12 PM


All times are GMT +1. The time now is 09:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"