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

Hi Fiona

You could use Conditional formatting.
Mark the range you want to formatFormatConditional Formattinguse dropdown
to select Formula is=MOD(ROW(),5)=0Choose a Format you wantOK

--
Regards
Roger Govier

"Fiona" wrote in message
...
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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Fiona" wrote:
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

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)



"Fiona" wrote in message
...
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