Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: making a cell change background color based on if positive or negative sum total

  1. #1
    Join Date
    3rd July 2006
    Posts
    2

    making a cell change background color based on if positive or negative sum total

    I have excel sheet with colored cells.

    Positive cash flow cells all have green background,
    Negative cash flow cells, all have red background.

    I calculate all the "sub-total" columns into one "total sum" cell.

    Based on this "total sum" I want the cell background to be red if the total sum is negative, or green if total sum is positive.

    How do I make the cell change to the proper background color based on whether it's a negative or postive total sum?

    (i.e. anything from .01 and up would be green backround color, anything from zero or less than zero, would be red background color)

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    4th May 2006
    Posts
    116

    Re: making a cell change background color based on if positive or negative sum total

    Use conditional formatting.
    Go to Data>Conditional Formatting and specify your criteria and the formatting accordingly.

    In your case,
    Condition 1:
    Cell value less than or equal to 0, format background red

    Condition 2:
    Cell value greater than 0, format background green

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    3rd July 2006
    Posts
    2

    Re: making a cell change background color based on if positive or negative sum total

    Thanks! Works great.


    Consider this issue resolved..........

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 7
    Last Post: August 7th, 2008, 12:47
  2. Number To Change Color For Positive & Negative
    By xindaiel in forum EXCEL HELP
    Replies: 2
    Last Post: December 6th, 2007, 06:54
  3. cell text based on a positive/negative value
    By toecutter in forum EXCEL HELP
    Replies: 5
    Last Post: May 12th, 2006, 09:16
  4. Change cell background color using VBA
    By SciFiJunkie in forum EXCEL HELP
    Replies: 2
    Last Post: August 5th, 2005, 08:23
  5. Change background color based on result
    By Stretch in forum EXCEL HELP
    Replies: 5
    Last Post: December 7th, 2004, 01:41

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno