+ Reply to Thread
Results 1 to 5 of 5

Conditional Formatting - format cells with zero value if row total is greater than zero.

  1. #1
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    818

    Conditional Formatting - format cells with zero value if row total is greater than zero.

    If the total of the row is 0, then no formatting to apply. If the total of the row is greater than zero, format only cells in the row that are 0. Cells that have values must have no formatting. I have attached a sample file.
    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,864

    Re: Conditional Formatting - format cells with zero value if row total is greater than zer

    File attach use conditional formatting.
    Attached Files Attached Files


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    818

    Re: Conditional Formatting - format cells with zero value if row total is greater than zer

    Thanks for your reply

  4. #4
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    818

    Re: Conditional Formatting - format cells with zero value if row total is greater than zer

    Apologies, I posted before finishing sentence. If the total of the row is greater than zero, format only cells in the row that are 0 (your file has no formatting in cells with zero values). Cells that have values must have no formatting (your file has formatting in cells with values.

  5. #5
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    818

    Re: Conditional Formatting - format cells with zero value if row total is greater than zer

    Thanks, I have managed to solve the issue.
    Attached Files Attached Files

+ 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 when difference between 2 cells is greater than 5%
    By ebburtis in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-02-2016, 11:24 AM
  2. [SOLVED] Conditional Formatting - The Greater of 2 Cells = Green
    By ThanksAlot in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-17-2015, 08:05 PM
  3. Conditional Format two consecutive cells greater than a set target
    By andrewedwards in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-03-2014, 09:14 AM
  4. Replies: 9
    Last Post: 02-16-2013, 10:11 PM
  5. Replies: 4
    Last Post: 10-18-2011, 02:54 PM
  6. Conditional Formatting Greater than surrounding Cells
    By tmiller in forum Excel General
    Replies: 1
    Last Post: 03-30-2007, 12:15 PM
  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