I have a spreadsheet that has 6 columns. I want to set up conditional
formatting on the whole row that will change the color of the row based on if
there is data entered in column 1, 2, or 6. If there is any value in column 1
I want the row to be red. When either 2 or 6 has data entered, the row should
turn yellow. When both 2 and 6 have data, the row turns green.