Link to home
Start Free TrialLog in
Avatar of JamesDBuskirk
JamesDBuskirkFlag for United States of America

asked on

Excel Conditional Statement Questionn

I am trying to write a conditional statement that will highlight a cell in the following scenario:

Let's say cell A1 says CYDCOR BEST BUY HSP and cell B1 says Store: CYDCOR CALL CENTER - BEST BUY, cell A2 says CYDCOR BEST BUY HSP and cell B2 says StOre: CYDCOR CALL CENTER - COSTCO.  I need the conditional statement to highlight cell B2 because it says CYDCOR CALL CENTER - COSTCO, not CYDCOR CALL CENTER - BEST BUY.
testjimmy.xlsx
Avatar of duttcom
duttcom
Flag of Australia image

You can do this by creating a new conditional formatting rule, choose "format only cells that contain", then in the dropdown at the bottom choose "Specific Text", then "not containing" in the next dropdown and then BEST BUY (with no double quotes). Set the format to whatever you want and only the sells not containing BEST BUY will be highlighted.

User generated image
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I would go with

=RIGHT($A1,1)<>RIGHT($B1,1)

User generated image
Hope it helps
Avatar of JamesDBuskirk

ASKER

Thank you all for your help and suggestions, this worked perfectly.