Ask Your Question

"and"-ing between two cells [closed]

asked 2017-04-01 15:40:37 +0100

GeertVc gravatar image

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 flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-28 21:23:17.133229


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

karolus gravatar imagekarolus ( 2017-04-01 16:01:23 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-04-01 15:56:11 +0100

karolus gravatar image


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

edit flag offensive delete link more


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

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

Question Tools

1 follower


Asked: 2017-04-01 15:40:37 +0100

Seen: 40 times

Last updated: Apr 01 '17