Prev: Variable Range in Formula
Next: Auto Page Numbering Question
From: dp on 13 May 2010 09:25
BTW (general question) is there some way to see and/or edit what conditional
formula had been used in a file? It looks like you can only make a new rule
or clear rules.

"T. Valko" wrote:

> >Excel 2007
> >cols A-E, rows 6-35.
> >if the answer in E is "done" then shade that row.
>
>
> Select the *entire* range A6:E35 starting from cell A6. Cell A6 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 Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a
> formula to determine which cells to format
> Enter this formula in the box below:
> =$E6="done"
> Click the Format button
> Select the desired style(s)
> OK out
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "dp" <dp(a)discussions.microsoft.com> wrote in message
> news:6FAF0857-9059-44A3-ADCF-66EB470CB6A1(a)microsoft.com...
> > Excel 2007. I've read other threads but somehow the answer eludes me.
> > All I need is shaded row(s) if the answer in E is "done" then shade that
> > row.
> > Simple spreadsheet cols A-E, rows 6-35. Formula ...?
> >
> > I can get the cell to shade with Equal to
> >
>
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Variable Range in Formula
Next: Auto Page Numbering Question