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.
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.
Apply to a range such as A2:Z the conditional formatting with the custom formula
=and($L2="APPROVED", $M2="APPROVED", $N2="APPROVED", $O2 = "X")