I'm trying to make a conditional formatting rule in Google Spreadsheet that would highlight a row green based on text in multiple cells.
If cells L2, M2, and N2 = APPROVED; and cell O2 = X; then row 2 = highlighted green.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
Apply to a range such as A2:Z the conditional formatting with the custom formula
=and($L2="APPROVED", $M2="APPROVED", $N2="APPROVED", $O2 = "X")