+ Reply to Thread
Results 1 to 2 of 2

Make a cell red/green if the value is positive/negative

  1. #1
    Registered User
    Join Date
    02-24-2012
    Location
    NE
    MS-Off Ver
    Excel 2010
    Posts
    1

    Make a cell red/green if the value is positive/negative

    How do you make a cell red/green if the value is positive or negative (gain loss) I have a metric i am tracking and i have the total % in the morning and the % in the evening. I need to track the % and make it easy to understand. So I want to make positive change green and negative change red i would be looking at change from morning to evening and change from evening to next morning. i am learning excel on my own so please forgive me if this is simple.
    Thanks for your help in advance.
    Last edited by mannyeat; 02-25-2012 at 11:53 AM.

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: How do you make a cell red/green if the value is positive or negative (gain loss)

    you would need to use conditional formating, select the cell/cells you want to format, then click on conditional formating -> new rule then go to "Format only cells that contain"

    from there you can set your conditions and desired format. you can do a second rule for the negatives
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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