Shading rows

[MichaelZ]

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.

 

[PCLIVE]

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]

Thanks, that works just fine.

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