1. Select the cell/Range (say A1:AB10). Please note that the cell reference
A1 mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection

2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula

=$A1="Partial"

4. Click Format ButtonPattern and select your color (say Yellow)
5. Add condition2 in the same way and Hit OK


If this post helps click Yes
---------------
Jacob Skaria


"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.