I attempting to conditionally format rows in a table(A12:M150), with a color shade based on text in a particular column in that row (J12:J150). There are 3 different Conditions in column (J), Active; Inactive; New. I want each row (A:M) to be conditionally formatted a different color based on the condition in column (J). Can anyone help?