Ask Your Question
0

"and"-ing between two cells

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 close merge delete

Comments

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
0

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

karolus gravatar image

Hallo

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

edit flag offensive delete link more

Comments

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 21 times

Last updated: Apr 01 '17