1
votes

I have a problem with set conditional formatting depends to sum 2 conditions

Spreadsheet column headers A:A Animal, B:B Name C:C Information

I need to highlight A2 if there will be in cells A2 Dog C2 Barking

Basically, it's just a kind of If A1="Dog" AND B1="Barking" THEN use highlight

Below link to example sheet https://docs.google.com/spreadsheets/d/1E0MiHpNFbIae-zQCTNppqoxrqiD1-v1bWyoLMvq7rYQ/edit?usp=sharing

Sheet View

EDIT:

Is there a possibility to add OR condition?

So total conditions will be something like this:

=AND($A1="Dog"; C1="Barking" OR C1="Scratching")
1
=AND($A1="Dog"; OR(C1="Barking"; C1="Scratching"))player0

1 Answers

0
votes

for row color:

=AND($A1="Dog"; $C1="Barking")

0


for cell color:

=AND($A1="Dog"; C1="Barking")

0