Have a spreadsheet and when a completion date goes in a cell I want the entire row of cells to change from the white background to a green background. Tried with conditional formatting but was only able to change the single cell not the whole row. Any ideas, thanks in advance.