Google Sheets row highlighting conditional formatting
// Based on one value =$D2 = 'Test' // Based on multiple values =AND($D2 = "Test_sites", $G2 <> "Soapbox")