I am trying to find a way to conditionally format an entire row in a spreadsheet to a specific color highlight. The data in each column is different. Is there a way to set up a "code" in a column, such as "1", "2", etec that would condtionally format the entire row. Or is there another way to do this?