I have a spreadsheet with data filled from Column A to Column AB. ColumnA
contains either "Partial" or "Completed". I tried putting cell value=Partial
then yellow shaded and cell value="Completed" then blue. It turns out that
only Column A with Partial or Completed is colored. Is it possible to color
the entire row from Column A to Column AB? Appreciate any tips. Thanks.