ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shading (https://www.excelbanter.com/excel-discussion-misc-queries/175734-shading.html)

Fiona

Shading
 
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[_3_]

Shading
 
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



Max

Shading
 
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


Bob Phillips

Shading
 
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





All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com