+ Reply to Thread
Results 1 to 4 of 4

Excel conditional formatting if two condition satisfies

  1. #1
    Registered User
    Join Date
    12-18-2019
    Location
    bhavnagar
    MS-Off Ver
    2016
    Posts
    3

    Excel conditional formatting if two condition satisfies

    I have excel sheet, which has value stored as price in "D" column

    now, I want to highlight particular cell in column "D" which satisfies below 2 conditions

    1 XFB9<=0.02
    2 which cell has highest value among cells that has fulfilled above condition (column "D")

    issue I find here in writing formula is, to define range Because, how do I define range to get highest value from that cell which fulfills no. 1 condition?, because it varies time to time

    I have written following formula in conditional formatting for no. 1 condition

    =XFB9<=0.02
    Kindly help with your solution on this issue, any help highly appriciated.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Excel conditional formatting if two condition satisfies

    =and(xfb$9<=0.02, d1=max(d:d))
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    12-18-2019
    Location
    bhavnagar
    MS-Off Ver
    2016
    Posts
    3

    Re: Excel conditional formatting if two condition satisfies

    I am here, posting image of my excel sheet, to better explain my question, above solution don't worked for me
    Attachment 695966

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,554

    Re: Excel conditional formatting if two condition satisfies

    Hello arshitpatel and Welcome to Excel Forum.
    Selecting the attachment in post #3 results in the following message: "Invalid Attachment specified. If you followed a valid link, please notify the administrator".
    It would be more useful if we could see a sample .xlsx file than a picture anyway. Please utilize the instructions in the banner at the top of the page.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Return a value on a row which satisfies a condition
    By allen003 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-23-2020, 07:39 AM
  2. Conditional formatting if the second sheet condition satisfies
    By suneeshpillai in forum Excel General
    Replies: 8
    Last Post: 03-12-2017, 03:06 PM
  3. If condition satisfies with multiple conditions
    By excel_hunt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2014, 02:09 PM
  4. how to use vlookup return only some condition satisfies
    By gillani77 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-29-2014, 06:11 PM
  5. how to use vlookup return only some condition satisfies
    By gvgbabu in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 04-28-2014, 07:37 PM
  6. A condition true if one element in a row of a matrix satisfies it
    By giovannioh in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-29-2010, 07:09 AM
  7. Copying rows which satisfies a filtering condition
    By blurtoad in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2007, 11:31 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1