Announcement

Collapse
No announcement yet.

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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)

  • #2
    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

    Comment


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

      Thanks! Works great.


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

      Comment

      Working...
      X