Google-sheets – Google Sheets – Conditional Formatting question

conditional formattinggoogle sheets

So I have it set that if a cell has a value of 0 to change the background to yellow. I want to have it so that if there are two 0's (zeros) next to each other in a row (edit: in adjoining cells not within the same cell) that it'll turn red (but not if there are two zeros in the row but separated by a value, only if they're beside each other).
I've tried searching but the other questions I found are different and I was struggling to adapt their solutions to my problem.

Edited to add image of what I want it to look like.

enter image description here

Best Answer

You would need 2 rules to achieve your results.
The 1st one -as you already mentioned- is Text contains 0
The 2nd is very similar to your 1st one Text contains 00

Filters must be in the correct order

Filters in the wrong order give you wrong results

Related Solutions

Google-sheets – Conditional Formatting based on another sheet’s content

Although you mention only A2 in sheet March I'm guessing you may want equivalent formatting throughout ColumnA, so start by selecting ColumnA then:

Format, Conditional formatting..., Custom formula is:

=match(A1,indirect("Roster"&"!D:D"),0)>0

select yellow (Range: should be A:A) and Save rules.

For each colour you need a separate rule (unless one colour is acceptable by default, so standard formatting applied for that) hence for red for example + Add another rule of:

=match(A1,indirect("Roster"&"!E:E"),0)>0

and repeat for blue (B:B in place of D:D in the first formula) and green (C:C).

Conditional Formatting with Asterisk Character in Google Sheets

You can achieve your desired results by putting a tilde, ~ in front of the asterisk as an escape character, if you put the conditional formatting rules in the order listed below.

First, create the one for orange when three asterisks occur using text contains and then specifying ~*~*~*. Select custom to pick an orange background. Then create the one for two asterisks using text contains and ~*~* picking yellow for the color. Then for the next rule create one for green with text contains and ~*. Then you can create the one with a red background using text is exactly specifying Dead and picking red for the background.

You should then see the following: