+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting colour scale-Include only cells containing value greater than 0

  1. #1
    Registered User
    Join Date
    06-11-2015
    Location
    Victoria, BC Canada
    MS-Off Ver
    2010
    Posts
    24

    Conditional formatting colour scale-Include only cells containing value greater than 0

    I have 5 different cells that return totals. At any point, as little as 2 of the 5 may have value and up to all 5. However when a colour scale is set to show highs and lows, it includes all cells including the empty ones. Excel thinks these values are 0 and include them in the scale. So the actual low number is coloured yellow rather than the green it should be. I want to only include values that are greater than zero in the colour scale.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Conditional formatting colour scale-Include only cells containing value greater than 0

    What are your current rules?

    Perhaps try and include something like =and(cell>0,your formula)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. 3 Colour Scale Conditional Formatting by Formula Type
    By swong1709 in forum Excel General
    Replies: 5
    Last Post: 03-05-2015, 07:14 AM
  2. Conditional Formatting using 3 colour scale from set cell
    By sgrprice in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-13-2015, 05:12 PM
  3. Replies: 4
    Last Post: 12-01-2014, 12:39 PM
  4. [SOLVED] conditional formatting range with colour scale
    By jstk886 in forum Excel General
    Replies: 2
    Last Post: 10-29-2013, 03:00 PM
  5. [SOLVED] 3 colour scale conditional formatting with actual vs. predicted figures.
    By Linsie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-19-2013, 08:56 AM
  6. Conditional formatting, three colour scale, how to use relative cell
    By marcopietro in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-12-2012, 07:38 AM
  7. Conditional formatting for the greater of 7 cells
    By guest123 in forum Excel General
    Replies: 8
    Last Post: 01-15-2007, 01:39 PM

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