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 tabStylesConditional FormattingManage rulesNew ruleUse 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" wrote in message
...
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



.