Highlighting rows in excel based on detecting number patterns across multiple cells

Question

I was wondering if there would be a way to highlight multiple rows based off of two distinct number patterns detected across the rows. Only one number either a 0 or 1 will appear in each cell but I am trying to detect the pattern across the row in three different cells like in the picture I provided. The two patterns I am looking to highlight are 0 0 0 and 0 1 0.

I'm open to a formula or VBA code I'm just lost as to how to structure this.

Answer 1

Add a formula in col H

$D2&$E2&$F2

Then use conditional formatting. You want Conditional Formatting>Highlight Cells>More Rules>Use a formula.. and use a formula like =OR($H2="000",$H2="010")

and apply it to your whole sheet (starting on row 2, or adjust the formula)