![]() |
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 |
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 |
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 |
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