Results 1 to 5 of 5

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

Threaded View

  1. 02-10-2017, 05:05 AM #1
    Aland2929
    Aland2929 is offline
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    858

    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
    Reply With QuoteRegister To Reply
« 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] 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. Conditional Format cells if greater than or less than zero
    By Mel B in forum Excel General
    Replies: 9
    Last Post: 02-16-2013, 10:11 PM
  5. Excel 2007 : Conditional Formatting, format if cell value (user input), is greater than
    By Spyderz in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1