"and"-ing between two cells

I want to apply a conditional format on a spreadsheet, but based on the content of two cells. I would like to do the following:

• Select the area in the worksheet
• Format +> Conditional Formatting => Condition => Formula is
• In the field next to "Formula is", I would like to apply the following: $B2="SomeText" AND$C2="SomeOtherText"

However, that doesn't work... When applying on ly $B2="SomeText", all works fine: all the rows in the selected area are nicely formatted the way I want it. What's wrong with my approach in the AND-ing condition? edit retag close merge delete Comments AND is a function not an Operator →→ AND( … ; … ) ( 2017-04-01 16:01:23 +0100 )edit 1 Answer Sort by » oldest newest most voted Hallo Try with Formula: $B2&\$C2="SomeTextSomeOtherText"

more

Wonderful solution, works perfect! Even with spaces in the text this solution is OK...

( 2017-04-01 16:11:39 +0100 )edit

Stats

Seen: 21 times

Last updated: Apr 01 '17