+ Reply to Thread
Results 1 to 5 of 5

Conditional Formula: to show values higher than two cells and if they are not blank

  1. #1
    Registered User
    Join Date
    06-22-2012
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2016
    Posts
    19

    Conditional Formula: to show values higher than two cells and if they are not blank

    Hello,

    Please help me. For some reason I cannot attach my file, so I will try to explain without it.
    I need to highlight values in column C that are higher than either column A or B but only if column A or B have values.
    Right now, this is my formula and it works partially. It highlights correctly with exception of third line, where my column A is blank. In this case C should not be highlighted because the value is smaller than B.
    =OR($C170>$A170,$C170>$B170)

    Is there any way to do this?

    Example:

    A B C
    0.5 0.5 1
    1 0.75 0.5
    2 1

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Conditional Formula: to show values higher than two cells and if they are not blank

    try

    =OR(AND($C1>$A1,$A1<>""),AND($C1>$B1,$B1<>""))
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Conditional Formula: to show values higher than two cells and if they are not blank

    Add 1 more condition :
    =AND(OR($C170>$A170,$C170>$B170),COUNT($A170:$B170)=2)
    Quang PT

  4. #4
    Registered User
    Join Date
    06-22-2012
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2016
    Posts
    19

    Re: Conditional Formula: to show values higher than two cells and if they are not blank

    It worked!!!!! Thank you both etaf and bebo02199. Both worked like magic!

  5. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Conditional Formula: to show values higher than two cells and if they are not blank

    each solution is different not the same result
    mine gives true for below

    bebo021999 is false

    for example
    A =2
    B =Blank
    C = 3

    then its true as C is greater than A
    but because B is blank did you want a false

+ 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. conditional formatting to show blank cells
    By Shamz41 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2018, 09:25 AM
  2. [SOLVED] Show Values When All 'Before Blank' Cells Are Empty
    By vill in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2017, 01:26 PM
  3. [SOLVED] Formula to show blank if two cells are blank
    By adrenom in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-09-2016, 05:10 PM
  4. how to show only labels with values higher than 0
    By vito1 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-15-2015, 08:51 AM
  5. [SOLVED] Cells with formula to show blank
    By Oeysbrei in forum Excel General
    Replies: 3
    Last Post: 07-11-2012, 03:55 AM
  6. Replies: 2
    Last Post: 05-31-2010, 03:23 PM
  7. Replies: 4
    Last Post: 07-23-2009, 03:18 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