Conditional Formatting the entire row
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.
|