Select the cells that you want to shade, open the CF dialog, choose
Formula and enter

=E1="done"

Change E1 to the first row to be shaded. The formatting needs to be
applied to all the cells in the rows, not just the cells in column E.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com



On Wed, 12 May 2010 10:05:02 -0700, dp
wrote:

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