+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting based on Text match from If Statement?

  1. #1
    Registered User
    Join Date
    11-05-2004
    Location
    Palm Springs California
    MS-Off Ver
    Office 2011 for Mac
    Posts
    37

    Conditional Formatting based on Text match from If Statement?

    I want to highlight a cell if the text displayed from an IF formula is equal to the cell content.

    CELLS BK10:BN10 are merged and have entered into them the following text "SELL"

    Cells BJ20:BP20 are merged and contain the following formula which currently results in the cell displaying "SELL"

    =IF(BM22<=-0.08,"SELL", IF(AND(BM22>-0.08,BM22 < -0.03),"NO INDICATION", IF(BM22>=-0.03,"HOLD")))

    Cell BM22 is a percentage calculation of the differences between two different days of volume for this stock and that formula is: =(BH22/BH25)-1 Cell BM22 currently is calculating the result to be -65.65%

    When I set up a CLASSIC Conditional Formatting using a formula (="If($BJ$20=""SELL""") to check the if the text in cells BK10 match the text displayed in cell BJ20 - I get no error messages and no formatting?

    I am using Mac Office Excel 2011. I feel like I have tried everything including changing the Number selection type of the cells to TEXT. Nothing seems to works. Thanks, grateful for the assistance, Michael

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Conditional Formatting based on Text match from If Statement?

    In conditional formatting rule use this

    =$BJ$20="SELL"

    format -- colour
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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 based on VLOOKUP/INDEX:MATCH
    By strud in forum Excel General
    Replies: 2
    Last Post: 06-13-2013, 07:02 AM
  2. [SOLVED] Conditional formatting based on VLOOKUP & HLOOKUP or MATCH
    By Joss.Terrell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-27-2012, 11:43 PM
  3. conditional formatting row based on text
    By lpratt in forum Excel General
    Replies: 5
    Last Post: 02-01-2011, 08:49 PM
  4. Conditional Formatting based on Text
    By avidcat in forum Excel General
    Replies: 3
    Last Post: 12-31-2010, 07:11 AM
  5. [SOLVED] Conditional formatting based on if statement.
    By kevin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-12-2005, 12:06 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