Make sure you select the entire range to be formatted (say A1:AB99)

and with A1 the activecell, use:
Formula is:
=$A1="Completed"

The $A will mean that only the value in column A will be checked for each cell
in that row (in your selection).

Since there is no $ in front of the row number, it'll change for each row in the
selected range.

cockatoo wrote:

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.

--

Dave Peterson