"and"-ing between two cells

[GeertVc]

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?

[karolus]

AND is a function not an Operator →→
AND( … ; … )

[karolus]

Hallo

Try with Formula: $B2&$C2="SomeTextSomeOtherText"

[GeertVc]

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