Try using an absolute reference in your Conditional Format formula. For
example, if the cell that contains the value "complete" is A1, then refer to
it as $A$1.

"Dino" wrote:

Is there a way to have Excel look in a particular cell, and if the value in
the cell meets a requirement (such as Complete), then shade the entire row a
different color? I can use conditional formatting to get the one cell
shaded, but I can't get the rest of the row to be shaded.

Thanks!
Dino