Shading

[Fiona]

Hi
I wondered if there was any way I caould shade certain lines in a document
automatically?

I want to shade every 5th row , on the whole document.

I hoped there may be a quicker way than going through the worksheet manually.

Many thanks

 

[Roger Govier]

Hi Fiona

You could use Conditional formatting.
Mark the range you want to format>Format>Conditional Formatting>use dropdown
to select Formula is>=MOD(ROW(),5)=0>Choose a Format you want>OK

 

[Max]

One play with Conditional Formatting
(xl2003 steps)

Select the entire sheet (A1 active), then
click Format> Conditional Formatting,
apply using Formula Is: =MOD(ROW(),5)=0,
Format the fill to taste (eg: green) > OK

Experiment with various values, eg:
=MOD(ROW(),5)=1,
=MOD(ROW(),5)=2, etc

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.CF.html#rows

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)