Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic hi-lite or shading every other line
Is there a way to have Excel, when printing, shade or hi-light every other
line? I have a lengthly spreadsheet on 11 X17 paper, and a small font, so viewing the sheet is hard. If every other line was hi-lighted, it might be easier. Any ideas? Thanks for your help! |
#2
|
|||
|
|||
Try using the following formula. First highlight the area that you want to
do a faux "green-bar". Then in Format/Conditional Formatting set condition 1to "Formula Is" and then type in: =MOD(ROW(),2)=0 Then select the format that you would like to use - color or pattern. This will produce the "every other line" formatting and will readjust the color or pattern if you insert a new line. Hope this helps, Amy "MarkT" wrote: Is there a way to have Excel, when printing, shade or hi-light every other line? I have a lengthly spreadsheet on 11 X17 paper, and a small font, so viewing the sheet is hard. If every other line was hi-lighted, it might be easier. Any ideas? Thanks for your help! |
#3
|
|||
|
|||
That did the trick!
Thank you very much! "cvgairport" wrote: Try using the following formula. First highlight the area that you want to do a faux "green-bar". Then in Format/Conditional Formatting set condition 1to "Formula Is" and then type in: =MOD(ROW(),2)=0 Then select the format that you would like to use - color or pattern. This will produce the "every other line" formatting and will readjust the color or pattern if you insert a new line. Hope this helps, Amy "MarkT" wrote: Is there a way to have Excel, when printing, shade or hi-light every other line? I have a lengthly spreadsheet on 11 X17 paper, and a small font, so viewing the sheet is hard. If every other line was hi-lighted, it might be easier. Any ideas? Thanks for your help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic hi-lite or shading every other line
"MarkT" wrote: Is there a way to have Excel, when printing, shade or hi-light every other line? I have a lengthly spreadsheet on 11 X17 paper, and a small font, so viewing the sheet is hard. If every other line was hi-lighted, it might be easier. Any ideas? Thanks for your help! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic hi-lite or shading every other line
t.bats wrote:
"MarkT" wrote: Is there a way to have Excel, when printing, shade or hi-light every other line? I have a lengthly spreadsheet on 11 X17 paper, and a small font, so viewing the sheet is hard. If every other line was hi-lighted, it might be easier. Any ideas? Thanks for your help! http://www.google.com/search?q=excel...ry+other+ row |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic hi-lite or shading every other line
Select range to format. Assume cell in upper left is cell A1, then
Format | Conditional Formatting Condition 1: Formula Is "=MOD(ROW(A1),2)=0" Push "Format" button Select "Patterns" tab Select desired background color Ok all dialog boxes "t.bats" wrote in message ... "MarkT" wrote: Is there a way to have Excel, when printing, shade or hi-light every other line? I have a lengthly spreadsheet on 11 X17 paper, and a small font, so viewing the sheet is hard. If every other line was hi-lighted, it might be easier. Any ideas? Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Line in line chart | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
How to force continuous lines in line charts | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Adding a text label to a line. | Charts and Charting in Excel |