+ Reply to Thread
Results 1 to 4 of 4

How to conditional format a range but ignore zero values

  1. 03-14-2018, 01:30 PM #1
    deichburg is offline
    Registered User
    Join Date
    03-14-2018
    Location
    TROY, MI
    MS-Off Ver
    2016
    Posts
    2

    How to conditional format a range but ignore zero values

    I have set up a conditional format for a range of cells using the "FORMULA TO DETERMINE WHICH CELLS TO FORMAT" rule type but would like to ignore the zero values. How can I do that?

    xlssnip.JPG
    Reply With QuoteRegister To Reply
  2. 03-14-2018, 01:41 PM #2
    Mazzaropi is offline
    Valued Forum Contributor
    Join Date
    05-13-2010
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    Excel 2003; 2007
    Posts
    441

    Re: How to conditional format a range but ignore zero values

    deichburg, Good afternoon.

    Try to use:
    Please Login or Register  to view this content.
    Please, tell us if it worked as wanted.

    I hope it helps.
    ...If my answer helped you, Please, click on. * Add Reputation (at left)

    Best regards.
    Marc?lio Lob?o
    Reply With QuoteRegister To Reply
  3. 03-14-2018, 01:53 PM #3
    deichburg is offline
    Registered User
    Join Date
    03-14-2018
    Location
    TROY, MI
    MS-Off Ver
    2016
    Posts
    2

    Re: How to conditional format a range but ignore zero values

    It worked like a charm - thank you!!
    Reply With QuoteRegister To Reply
  4. 03-14-2018, 02:41 PM #4
    Mazzaropi is offline
    Valued Forum Contributor
    Join Date
    05-13-2010
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    Excel 2003; 2007
    Posts
    441

    Re: How to conditional format a range but ignore zero values

    deichburg,

    Glad to have helped you.

    Thanks for the feedback.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to make Conditional Formatting Ignore '+' & '-' values
    By liamfrancis2013 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-24-2017, 10:36 AM
  2. [SOLVED] Make conditional format ignore blank cells.
    By Graham Pall in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-22-2015, 09:15 AM
  3. [SOLVED] conditional format to highlight values out of range
    By Excel_learner in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-10-2015, 10:34 PM
  4. [SOLVED] Conditional format duplicates ignore certain criteria
    By spoursy in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-31-2014, 07:49 AM
  5. Ignore blank cells in conditional format
    By hbiglay in forum Excel General
    Replies: 18
    Last Post: 05-20-2014, 12:39 PM
  6. [SOLVED] Conditional Format color of cell based on values in a range of cells
    By Mitchel in forum Excel General
    Replies: 5
    Last Post: 10-24-2013, 05:34 PM
  7. Conditional format for value in A1 but ignore if A2 is not blank Excel 2010
    By foxtrtr in forum Excel General
    Replies: 2
    Last Post: 12-16-2011, 10:35 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1