0

I wanted to compare the price range column which will have prices range like 450-500 to another cell value 703.
In this image you can see I need to find column D value (which is the price range) to Column F which will be the current market price (CMP) which will change every day.
If it falls under the price range I need that cell to be highlighted.

enter image description here

  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it and maybe upvote it so others can benefit as well. – marikamitsos Sep 24 at 20:37
1

You should use the following formula having an IF statement:

=(IFERROR(MAX(SPLIT(D3,"-")),0))>F3

cond. formatting

  • Have you tried the solution offered? Did it work for you? If not we should try finding out why. If yes, as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. – marikamitsos Sep 29 at 11:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.