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.

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

Select the *entire* range of cells you want to format.

Let's assume you want to format A1:AB10

Select the *entire* range A1:AB10 starting from cell A1. Cell A1 will be the
active cell. The active cell is the one cell in the selected range that is
not shaded. The formula will be relative to the active cell.

Goto the menu FormatConditional Formatting

Condition 1
Select the Formula Is option
Enter this formula in the box on the right:
=$A1="Partial"
Click the Format button
Select the desired style(s)
Click the Add button

Condition 2
Select the Formula Is option
Enter this formula in the box on the right:
=$A1="Completed"
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"cockatoo" wrote in message
...
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.

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.