+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting Percentages Red to Green - Negatives Red, Positives Green

  1. #1
    Registered User
    Join Date
    01-04-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Conditional Formatting Percentages Red to Green - Negatives Red, Positives Green

    Hi All,

    I'm trying to conditional format cells containing percentages so that the highest positive percent will be the brightest green fill and the lowest negative number will be the brightest red fill. However, I only want negatives to be filled with red and positives to be filled with green with zero being filled with white.

    I hope this makes sense. I tried conditional formatting using a color scale with red to green, but it just goes lowest to highest. If all of your numbers are positive, it will color positive cells red, which I think could be a little confusing.

    Any help would be greatly appreciated.

    Thanks

  2. #2
    Forum Contributor
    Join Date
    11-12-2013
    Location
    Delhi
    MS-Off Ver
    Excel 2016
    Posts
    135

    Re: Conditional Formatting Percentages Red to Green - Negatives Red, Positives Green

    go to home > style > condition formatting > new rule > format cell on the condition


    or pls share ur sheet so that I can put conditional formatting for you

    many thanks
    Rishi Saw

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional formatting - one cell green rest no colour
    By HHR in forum Excel General
    Replies: 15
    Last Post: 01-31-2013, 02:26 PM
  2. Replies: 6
    Last Post: 08-23-2012, 12:14 PM
  3. Help with conditional formatting:green pattern
    By vikkam in forum Excel General
    Replies: 5
    Last Post: 01-03-2007, 01:46 AM
  4. conditional formatting COLOR - pale green
    By LTUser54 in forum Excel General
    Replies: 2
    Last Post: 05-19-2006, 10:37 AM
  5. Conditional formatting-green above a certain value
    By Brisbane Rob in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-05-2006, 03:11 PM

Tags for this Thread

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