Use Conditional formatting from the Format menu.

Highlight (select) all of the rows that you want shaded based on this
condition.
Click Format|Conditional Formatting
Change to Formula Is
Where B2 is the first row of your highlighted selection, type: =$B2="no"
Click the Format button.
Click the Patterns tab.
Select your shading color.
Click OK.
Click OK.


HTH,
Paul




--

"MichaelZ" wrote in message
...
How can I shade multiple rows at the same time? In this case I want to
shade
the entire row each time the cell in Column B has the string "no".

Thanks in advance for your help.