Shading rows
 

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.

Shading rows
 

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.

Shading rows
 

Thanks, that works just fine.

"PCLIVE" wrote:

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.