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
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")
=AND($A1="Dog"; OR(C1="Barking"; C1="Scratching"))
– player0