Results 1 to 15 of 15

Formula to Change Colors If Total Numbers Gain or Lose

Threaded View

  1. #1
    Registered User
    Join Date
    07-24-2015
    Location
    Missouri
    MS-Off Ver
    2013
    Posts
    16

    Question Formula to Change Colors If Total Numbers Gain or Lose

    Hey Excel Forums, your buddy Noc here ready for round two! I am more of an organizing kind of person, so forgive me if these are really basic problems. Anyway, I am trying to get a system where if the number from the "gain/loss" changes, it will turn green if it gains and then red if it loses. So even if it gains for now, it might decrease from the next update. If it's green from an increase, I need it to turn red if it decreases later. Thank you for having me! Edit: Sorry if I was a little redundant haha.
    Attached Files Attached Files
    Last edited by NocSparta; 07-25-2015 at 07:46 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 03-10-2015, 07:28 AM
  2. Days Total Gain (%) - no pivot table
    By domgilberto in forum Excel General
    Replies: 18
    Last Post: 01-14-2015, 11:01 AM
  3. Formula for gain and loss within a column with a single cell running total
    By unusually_usual in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2011, 10:22 AM
  4. Replies: 4
    Last Post: 03-29-2009, 01:37 AM
  5. Replies: 1
    Last Post: 10-07-2006, 01:01 PM
  6. [SOLVED] How do I change row text colors in Excel based on formula?
    By ggliddy in forum Excel General
    Replies: 1
    Last Post: 11-14-2005, 03:30 PM
  7. Spreadsheet to do annual investment gain$, % gain, for list
    By notaspreadsheetgenius in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-09-2005, 04:08 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1