Shading rows

M

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.
 
P

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
 
M

MichaelZ

Thanks, that works just fine.

PCLIVE said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make the shading look uniform around a double spaced line in MS Word? 0
Indenting every other paragraph in Word at the same time? 0
table shading prints differently on different pages 0
Sorting Multiple Tables 1
Copy addition formula of non-consecutive horizontal cells 2
Shade a Cell 7
How to shade groups of rows in excel. 1
Repeating a row other than the 1st row as the header row in a table from next page 1

Top